<report xmlns="http://developer.cognos.com/schemas/report/12.0/" expressionLocale="en-us" useStyleVersion="10"><!--RSU-SPC-0093 The report specification was upgraded from "http://developer.cognos.com/schemas/report/11.0/" to "http://developer.cognos.com/schemas/report/12.0/" at 2016-3-30. 16:23:32-->
				<modelPath>/content/folder[@name='Packages']/package[@name='Storage and Storage Pool Capacity']/model[@name='model']</modelPath>
				<drillBehavior modelBasedDrillThru="true"/>
				
				<layouts>
					<layout>
						<reportPages>
							
						<pageSet name="Application" refQuery="Application Prompt">
			<detailPages><page name="Page1"><style><defaultStyles><defaultStyle refStyle="pg"/></defaultStyles><CSS value="width:1400px"/></style>
								<pageBody><style><defaultStyles><defaultStyle refStyle="pb"/></defaultStyles></style>
									<contents>
										
									<HTMLItem>
			<dataSource>
				<staticValue>&lt;style&gt; #headerBack { display: none; } .mainHeader1 { display: none; } .mainViewerHeader3 { display: none; } &lt;/style&gt;</staticValue>
			</dataSource>
		</HTMLItem><list showColumnTitles="hide" refQuery="Application Prompt" name="List2">
			<listColumns>
				<listColumn>
					<listColumnTitle>
						<contents/>
					</listColumnTitle>
					<listColumnBody>
						<contents><list horizontalPagination="true" name="List1" refQuery="Application Prompt">
			
			
			
			<noDataHandler>
				<contents>
					<block>
						<contents>
							<textItem>
								<dataSource>
									<staticValue>No Data Available</staticValue>
								</dataSource>
								<style>
									<CSS value="padding:10px 18px;"/>
								</style>
							</textItem>
						</contents>
					</block>
				</contents>
			</noDataHandler>
			<style>
				<CSS value="border-collapse:collapse;border:1pt solid white"/>
				<defaultStyles>
					<defaultStyle refStyle="ls"/>
				</defaultStyles>
			</style>
		<listColumns><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="display:none"/></style><contents><textItem><dataSource><staticValue>Table</staticValue></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lc"/></defaultStyles></style><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:1375px"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Powered by OnCommand Insight</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:bold;color:white"/></style></textItem></contents><style><CSS value="height:24px;background-color:#6198C5;padding-left:10px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Application Capacity and Performance Trends with Forecast</staticValue></dataSource></textItem></contents><style><CSS value="height:36px;padding-left:10px;font-family:Arial;font-size:24px;color:#333333;background-color:#FBFBFB;border-bottom:1px solid #E1E1E2"/></style></tableCell></tableCells></tableRow></tableRows></table></contents></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Application: </staticValue></dataSource><style><CSS value="font-family:Arial;font-size:24px;font-weight:bold;color:#808080"/></style></textItem><repeater name="Repeater7" refQuery="Application Prompt">
			<contents><textItem><dataSource><dataItemValue refDataItem="Application"/></dataSource><style><CSS value="font-family:Arial;font-size:24px;font-weight:bold;color:#808080"/></style></textItem></contents>
		<masterDetailLinks><masterDetailLink><masterContext><dataItemContext refDataItem="Application"/></masterContext><detailContext><dataItemContext refDataItem="Application"/></detailContext></masterDetailLink></masterDetailLinks></repeater></contents><style><CSS value="padding-top:10px;padding-bottom:5px;padding-left:35px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Allocated Capacity</staticValue></dataSource></textItem></contents><style><CSS value="padding-top:5px;padding-left:5px;font-family:Arial;font-size:14px;color:#656565"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><repeater name="Repeater1" refQuery="Chargeback + Performance Metrics - ETL">
			<contents><textItem><dataSource><dataItemValue refDataItem="Allocated (GB)"/></dataSource><style><CSS value="font-family:Arial;font-size:36px;font-weight:bold;color:#808080"/><dataFormat><numberFormat pattern="###,### GB"/></dataFormat></style></textItem></contents>
		<masterDetailLinks><masterDetailLink><masterContext><dataItemContext refDataItem="Application"/></masterContext><detailContext><parameterContext parameter="sApp"/></detailContext></masterDetailLink></masterDetailLinks></repeater></contents><style><CSS value="padding-left:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="padding-left:5px;padding-bottom:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:30px;border-right:2px solid #ADB2B5"/></style></tableCell><tableCell><contents/><style><CSS value="width:5px"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Used Capacity</staticValue></dataSource></textItem></contents><style><CSS value="padding-top:5px;padding-left:5px;font-family:Arial;font-size:14px;color:#656565"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><repeater name="Repeater2" refQuery="Chargeback + Performance Metrics - ETL">
			<contents><textItem><dataSource><dataItemValue refDataItem="Used (GB)"/></dataSource><style><CSS value="font-family:Arial;font-size:36px;font-weight:bold;color:#808080"/><dataFormat><numberFormat pattern="###,### GB"/></dataFormat></style></textItem></contents>
		<masterDetailLinks><masterDetailLink><masterContext><dataItemContext refDataItem="Application"/></masterContext><detailContext><parameterContext parameter="sApp"/></detailContext></masterDetailLink></masterDetailLinks></repeater></contents><style><CSS value="padding-left:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="padding-left:5px;padding-bottom:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:30px;border-right:2px solid #ADB2B5"/></style></tableCell><tableCell><contents/><style><CSS value="width:5px"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>% Used</staticValue></dataSource></textItem></contents><style><CSS value="padding-top:5px;padding-left:5px;font-family:Arial;font-size:14px;color:#656565"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><repeater name="Repeater3" refQuery="Chargeback + Performance Metrics - ETL">
			<contents><textItem><dataSource><dataItemValue refDataItem="Used (%)"/></dataSource><style><CSS value="font-family:Arial;font-size:36px;font-weight:bold;color:#808080"/><dataFormat><percentFormat/></dataFormat></style></textItem></contents>
		<masterDetailLinks><masterDetailLink><masterContext><dataItemContext refDataItem="Application"/></masterContext><detailContext><parameterContext parameter="sApp"/></detailContext></masterDetailLink></masterDetailLinks></repeater></contents><style><CSS value="padding-left:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="padding-left:5px;padding-bottom:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:30px;border-right:2px solid #ADB2B5"/></style></tableCell><tableCell><contents/><style><CSS value="width:5px"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Average IOpS</staticValue></dataSource></textItem></contents><style><CSS value="padding-top:5px;padding-left:5px;font-family:Arial;font-size:14px;color:#656565"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><repeater name="Repeater4" refQuery="Chargeback + Performance Metrics - ETL">
			<contents><textItem><dataSource><dataItemValue refDataItem="Total Average IOPS"/></dataSource><style><CSS value="font-family:Arial;font-size:36px;font-weight:bold;color:#808080"/><dataFormat><numberFormat pattern="###,### IOs"/></dataFormat></style></textItem></contents>
		<masterDetailLinks><masterDetailLink><masterContext><dataItemContext refDataItem="Application"/></masterContext><detailContext><parameterContext parameter="sApp"/></detailContext></masterDetailLink></masterDetailLinks></repeater></contents><style><CSS value="padding-left:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="padding-left:5px;padding-bottom:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:30px;border-right:2px solid #ADB2B5"/></style></tableCell><tableCell><contents/><style><CSS value="width:5px"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Average Latency</staticValue></dataSource></textItem></contents><style><CSS value="padding-top:5px;padding-left:5px;font-family:Arial;font-size:14px;color:#656565"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><repeater name="Repeater5" refQuery="Chargeback + Performance Metrics - ETL">
			<contents><textItem><dataSource><dataItemValue refDataItem="Average Latency"/></dataSource><style><CSS value="font-family:Arial;font-size:36px;font-weight:bold;color:#808080"/><dataFormat><numberFormat pattern="###.## ms"/></dataFormat></style></textItem></contents>
		<masterDetailLinks><masterDetailLink><masterContext><dataItemContext refDataItem="Application"/></masterContext><detailContext><parameterContext parameter="sApp"/></detailContext></masterDetailLink></masterDetailLinks></repeater></contents><style><CSS value="padding-left:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="padding-left:5px;padding-bottom:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:30px;border-right:2px solid #ADB2B5"/></style></tableCell><tableCell><contents/><style><CSS value="width:5px"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Average Throughput</staticValue></dataSource></textItem></contents><style><CSS value="padding-top:5px;padding-left:5px;font-family:Arial;font-size:14px;color:#656565"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><repeater name="Repeater6" refQuery="Chargeback + Performance Metrics - ETL">
			<contents><textItem><dataSource><dataItemValue refDataItem="Total Average MB/s"/></dataSource><style><CSS value="font-family:Arial;font-size:36px;font-weight:bold;color:#808080"/><dataFormat><numberFormat pattern="###,### MBps"/></dataFormat></style></textItem></contents>
		<masterDetailLinks><masterDetailLink><masterContext><dataItemContext refDataItem="Application"/></masterContext><detailContext><parameterContext parameter="sApp"/></detailContext></masterDetailLink></masterDetailLinks></repeater></contents><style><CSS value="padding-left:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="padding-left:5px;padding-bottom:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:30px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="background-color:#F7F7F7;padding-bottom:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Capacity Utilization Trend and Forecast</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue>(Six Months)</staticValue></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<v2_combinationChart maxHotspots="10000" name="Combination Chart8" refQuery="Application Forecast - ETL">
																				<v2_combinationTypeTooltips/>
																				<v2_commonAxis>
																					<v2_ordinalAxis>
																						<v2_axisLabels>
																							<style>
																								<defaultStyles>
																									<defaultStyle refStyle="al"/>
																								</defaultStyles>
																							<CSS value="font-family:Arial;color:#454545"/></style>
																						</v2_axisLabels>
																					</v2_ordinalAxis>
																					<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Date"><chartContents><chartTextItem><dataSource><dataItemValue refDataItem="Date"/></dataSource></chartTextItem></chartContents><style><dataFormat><dateFormat pattern="yyyy-MM"/></dataFormat></style></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
																				<v2_topLeftAxis>
																					<v2_combinationChartTypes>
																						<v2_line lineAreaShape="smooth" lineDisplayType="lineAndMarkers"><v2_linePalette markerBorderColor="white" markerBorders="show" markerSize="8px"><v2_linePaletteEntries><v2_linePaletteEntry lineWeight="2px"><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#8599D3"><v2_solidColor color="#9ABCC3" transparency="30"/></v2_fillEffect></v2_pointPaletteEntry><v2_lineFill defaultColor="#8599D3"><v2_color color="#9ABCC3"/></v2_lineFill></v2_linePaletteEntry><v2_linePaletteEntry lineWeight="2px" lineStyle="dash_dot"><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#E3AE6C"><v2_solidColor color="#A8E3D7" transparency="30"/></v2_fillEffect></v2_pointPaletteEntry><v2_lineFill defaultColor="#E3AE6C"><v2_color color="#A8E3D7"/></v2_lineFill></v2_linePaletteEntry><v2_linePaletteEntry><v2_lineFill defaultColor="#198545"><v2_color color="#88B2D3"/></v2_lineFill><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#198545"/></v2_fillEffect></v2_pointPaletteEntry></v2_linePaletteEntry><v2_linePaletteEntry><v2_lineFill defaultColor="#198545"><v2_color color="#FFB2C1"/></v2_lineFill><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#198545"/></v2_fillEffect></v2_pointPaletteEntry></v2_linePaletteEntry></v2_linePaletteEntries></v2_linePalette><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="UsedGB"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode><chartNode><chartNodeMembers><chartNodeMember refDataItem="ProjectedUsedGB"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_line></v2_combinationChartTypes>
																					<v2_axis>
																						<v2_axisRange scale="linear">
																							
																						<v2_automaticRange sameRangeAllInstances="true" includeZeroForAutoScale="true"/></v2_axisRange>
																						<v2_axisLabels>
																							<style>
																								<defaultStyles>
																									<defaultStyle refStyle="al"/>
																								</defaultStyles>
																							<CSS value="font-family:Arial;color:#454545"/><dataFormat><numberFormat pattern="###,### GB"/></dataFormat></style>
																						</v2_axisLabels>
																						<v2_majorGridlines lineColor="#EEEEF0" lineWeight="0"/>
																					</v2_axis>
																				</v2_topLeftAxis>
																				<style>
																					<defaultStyles>
																						<defaultStyle refStyle="ch"/>
																					</defaultStyles>
																					<CSS value="width:1400px;height:150px"/></style>
																				
																				<v2_legend>
																					<v2_legendPosition>
																						<v2_legendPreset legendPositionPreset="bottom"/>
																					</v2_legendPosition>
																					<style>
																						<defaultStyles>
																							<defaultStyle refStyle="lg"/>
																						</defaultStyles>
																					<CSS value="font-family:Arial;color:#454545"/></style>
																				</v2_legend>
																				<XMLAttributes><XMLAttribute name="titlesExpanded" output="no" value="true"/></XMLAttributes><masterDetailLinks><masterDetailLink><masterContext><dataItemContext refDataItem="Application"/></masterContext><detailContext><parameterContext parameter="sApp"/></detailContext></masterDetailLink></masterDetailLinks></v2_combinationChart></contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="background-color:#F7F7F7;padding-top:5px;padding-right:10px;padding-left:10px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Average IOpS Trend</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue>(30 Day)</staticValue></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<v2_combinationChart maxHotspots="10000" name="Combination Chart3" refQuery="Performance Trends - ETL">
                                                                                                        <v2_combinationTypeTooltips/>
                                                                                                        <v2_commonAxis>
                                                                                                            <v2_ordinalAxis>
                                                                                                                <v2_axisLine lineColor="#E1E1E2" lineWeight="0"/>
                                                                                                                <v2_axisLabels>
                                                                                                                    <style>
                                                                                                                        <defaultStyles>
                                                                                                                            <defaultStyle refStyle="al"/>
                                                                                                                        </defaultStyles>
                                                                                                                    <CSS value="color:#454545"/></style>
                                                                                                                </v2_axisLabels>
                                                                                                            </v2_ordinalAxis>
                                                                                                            <chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Date"><chartContents><chartTextItem><dataSource><dataItemValue refDataItem="Date"/></dataSource></chartTextItem></chartContents><style><dataFormat><dateFormat pattern="MM/dd"/></dataFormat></style></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
                                                                                                        <v2_topLeftAxis>
                                                                                                            <v2_combinationChartTypes>
                                                                                                                <v2_area lineAreaShape="smooth" seriesType="stacked">
                                                                                                                    <v2_solidPalette>
                                                                                                                        
                                                                                                                    <v2_solidPaletteEntries><v2_solidPaletteEntry><v2_fillEffect defaultColor="#0084e3">
																											<v2_solidColor transparency="0" color="#88B2D3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#000066">
																											<v2_solidColor color="#EBC4B6"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99CCFF">
																											<v2_solidColor color="#B8B8BF"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#336699">
																											<v2_solidColor color="#D1B3D9"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99AACC">
																											<v2_solidColor color="#9AD7CD"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#999999">
																											<v2_solidColor color="#FFB2C1"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#F3F3F3">
																											<v2_solidColor color="#FDCF9B"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E7E7E7">
																											<v2_solidColor color="#E7E7E7"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E3E9F3">
																											<v2_solidColor color="#E3E9F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#CCCCCC">
																											<v2_solidColor color="#CCCCCC"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry></v2_solidPaletteEntries></v2_solidPalette>
                                                                                                                    <!-- v2_solidPaletteRef ref=&amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;quot;gDefaultSolid&amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;quot;/ -->
                                                                                                                <chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Total IOpS"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_area>
                                                                                                            </v2_combinationChartTypes>
                                                                                                            <v2_axis>
                                                                                                                <v2_axisRange>
                                                                                                                    <v2_automaticRange/>
                                                                                                                </v2_axisRange>
                                                                                                                <v2_axisLabels>
                                                                                                                    <style>
                                                                                                                        <defaultStyles>
                                                                                                                            <defaultStyle refStyle="al"/>
                                                                                                                        </defaultStyles>
                                                                                                                    <CSS value="color:#454545"/><dataFormat><numberFormat pattern="###,### IOs"/></dataFormat></style>
                                                                                                                </v2_axisLabels>
                                                                                                                <v2_majorGridlines lineColor="#EEEEF0" lineWeight="0"/>
                                                                                                            </v2_axis>
                                                                                                        </v2_topLeftAxis>
                                                                                                        <style>
                                                                                                            <defaultStyles>
                                                                                                                <defaultStyle refStyle="ch"/>
                                                                                                            </defaultStyles>
                                                                                                            <CSS value="width:448px;height:175px;font-family:Arial"/></style>
                                                                                                        
                                                                                                        <XMLAttributes><XMLAttribute name="titlesExpanded" output="no" value="true"/></XMLAttributes><masterDetailLinks><masterDetailLink><masterContext><dataItemContext refDataItem="Application"/></masterContext><detailContext><parameterContext parameter="sApp"/></detailContext></masterDetailLink></masterDetailLinks></v2_combinationChart></contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Average Latency Trend</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue>(30 Day)</staticValue></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<v2_combinationChart maxHotspots="10000" name="Combination Chart4" refQuery="Performance Trends - ETL">
                                                                                                        <v2_combinationTypeTooltips/>
                                                                                                        <v2_commonAxis>
                                                                                                            <v2_ordinalAxis>
                                                                                                                <v2_axisLine lineColor="#E1E1E2" lineWeight="0"/>
                                                                                                                <v2_axisLabels>
                                                                                                                    <style>
                                                                                                                        <defaultStyles>
                                                                                                                            <defaultStyle refStyle="al"/>
                                                                                                                        </defaultStyles>
                                                                                                                    <CSS value="color:#454545"/></style>
                                                                                                                </v2_axisLabels>
                                                                                                            </v2_ordinalAxis>
                                                                                                            <chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Date"><chartContents><chartTextItem><dataSource><dataItemValue refDataItem="Date"/></dataSource></chartTextItem></chartContents><style><dataFormat><dateFormat pattern="MM/dd"/></dataFormat></style></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
                                                                                                        <v2_topLeftAxis>
                                                                                                            <v2_combinationChartTypes>
                                                                                                                <v2_area lineAreaShape="smooth" seriesType="stacked">
                                                                                                                    <v2_solidPalette>
                                                                                                                        
                                                                                                                    <v2_solidPaletteEntries><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99AACC">
																											<v2_solidColor color="#9AD7CD"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#0084e3">
																											<v2_solidColor transparency="0" color="#88B2D3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#000066">
																											<v2_solidColor color="#EBC4B6"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99CCFF">
																											<v2_solidColor color="#B8B8BF"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#336699">
																											<v2_solidColor color="#D1B3D9"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#999999">
																											<v2_solidColor color="#FFB2C1"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#F3F3F3">
																											<v2_solidColor color="#FDCF9B"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E7E7E7">
																											<v2_solidColor color="#E7E7E7"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E3E9F3">
																											<v2_solidColor color="#E3E9F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#CCCCCC">
																											<v2_solidColor color="#CCCCCC"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry></v2_solidPaletteEntries></v2_solidPalette>
                                                                                                                    <!-- v2_solidPaletteRef ref=&amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;quot;gDefaultSolid&amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;quot;/ -->
                                                                                                                <chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Total Latency (ms)"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_area>
                                                                                                            </v2_combinationChartTypes>
                                                                                                            <v2_axis>
                                                                                                                <v2_axisRange>
                                                                                                                    <v2_automaticRange/>
                                                                                                                </v2_axisRange>
                                                                                                                <v2_axisLabels>
                                                                                                                    <style>
                                                                                                                        <defaultStyles>
                                                                                                                            <defaultStyle refStyle="al"/>
                                                                                                                        </defaultStyles>
                                                                                                                    <CSS value="color:#454545"/><dataFormat><numberFormat pattern="###.## ms"/></dataFormat></style>
                                                                                                                </v2_axisLabels>
                                                                                                                <v2_majorGridlines lineColor="#EEEEF0" lineWeight="0"/>
                                                                                                            </v2_axis>
                                                                                                        </v2_topLeftAxis>
                                                                                                        <style>
                                                                                                            <defaultStyles>
                                                                                                                <defaultStyle refStyle="ch"/>
                                                                                                            </defaultStyles>
                                                                                                            <CSS value="width:448px;height:175px;font-family:Arial"/></style>
                                                                                                        
                                                                                                        <XMLAttributes><XMLAttribute name="titlesExpanded" output="no" value="true"/></XMLAttributes><masterDetailLinks><masterDetailLink><masterContext><dataItemContext refDataItem="Application"/></masterContext><detailContext><parameterContext parameter="sApp"/></detailContext></masterDetailLink></masterDetailLinks></v2_combinationChart></contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:5px"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Average Throughput Trend</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue>(30 Day)</staticValue></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<v2_combinationChart maxHotspots="10000" name="Combination Chart5" refQuery="Performance Trends - ETL">
                                                                                                        <v2_combinationTypeTooltips/>
                                                                                                        <v2_commonAxis>
                                                                                                            <v2_ordinalAxis>
                                                                                                                <v2_axisLine lineColor="#E1E1E2" lineWeight="0"/>
                                                                                                                <v2_axisLabels>
                                                                                                                    <style>
                                                                                                                        <defaultStyles>
                                                                                                                            <defaultStyle refStyle="al"/>
                                                                                                                        </defaultStyles>
                                                                                                                    <CSS value="color:#454545"/></style>
                                                                                                                </v2_axisLabels>
                                                                                                            </v2_ordinalAxis>
                                                                                                            <chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Date"><chartContents><chartTextItem><dataSource><dataItemValue refDataItem="Date"/></dataSource></chartTextItem></chartContents><style><dataFormat><dateFormat pattern="MM/dd"/></dataFormat></style></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
                                                                                                        <v2_topLeftAxis>
                                                                                                            <v2_combinationChartTypes>
                                                                                                                <v2_area lineAreaShape="smooth" seriesType="stacked">
                                                                                                                    <v2_solidPalette>
                                                                                                                        
                                                                                                                    <v2_solidPaletteEntries><v2_solidPaletteEntry><v2_fillEffect defaultColor="#F3F3F3">
																											<v2_solidColor color="#FDCF9B"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#0084e3">
																											<v2_solidColor transparency="0" color="#88B2D3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#000066">
																											<v2_solidColor color="#EBC4B6"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99CCFF">
																											<v2_solidColor color="#B8B8BF"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#336699">
																											<v2_solidColor color="#D1B3D9"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99AACC">
																											<v2_solidColor color="#9AD7CD"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#999999">
																											<v2_solidColor color="#FFB2C1"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E7E7E7">
																											<v2_solidColor color="#E7E7E7"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E3E9F3">
																											<v2_solidColor color="#E3E9F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#CCCCCC">
																											<v2_solidColor color="#CCCCCC"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry></v2_solidPaletteEntries></v2_solidPalette>
                                                                                                                    <!-- v2_solidPaletteRef ref=&amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;quot;gDefaultSolid&amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;quot;/ -->
                                                                                                                <chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Total MBps"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_area>
                                                                                                            </v2_combinationChartTypes>
                                                                                                            <v2_axis>
                                                                                                                <v2_axisRange>
                                                                                                                    <v2_automaticRange/>
                                                                                                                </v2_axisRange>
                                                                                                                <v2_axisLabels>
                                                                                                                    <style>
                                                                                                                        <defaultStyles>
                                                                                                                            <defaultStyle refStyle="al"/>
                                                                                                                        </defaultStyles>
                                                                                                                    <CSS value="color:#454545"/><dataFormat><numberFormat pattern="###,###.## MBps"/></dataFormat></style>
                                                                                                                </v2_axisLabels>
                                                                                                                <v2_majorGridlines lineColor="#EEEEF0" lineWeight="0"/>
                                                                                                            </v2_axis>
                                                                                                        </v2_topLeftAxis>
                                                                                                        <style>
                                                                                                            <defaultStyles>
                                                                                                                <defaultStyle refStyle="ch"/>
                                                                                                            </defaultStyles>
                                                                                                            <CSS value="width:448px;height:175px;font-family:Arial"/></style>
                                                                                                        
                                                                                                        <XMLAttributes><XMLAttribute name="titlesExpanded" output="no" value="true"/></XMLAttributes><masterDetailLinks><masterDetailLink><masterContext><dataItemContext refDataItem="Application"/></masterContext><detailContext><parameterContext parameter="sApp"/></detailContext></masterDetailLink></masterDetailLinks></v2_combinationChart></contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell colSpan="3"><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>CPU Utilization</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue>(30 Day)</staticValue></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<v2_combinationChart maxHotspots="10000" name="Combination Chart6" refQuery="Performance Trends - ETL">
                                                                                                        <v2_combinationTypeTooltips/>
                                                                                                        <v2_commonAxis>
                                                                                                            <v2_ordinalAxis>
                                                                                                                <v2_axisLine lineColor="#E1E1E2" lineWeight="0"/>
                                                                                                                <v2_axisLabels>
                                                                                                                    <style>
                                                                                                                        <defaultStyles>
                                                                                                                            <defaultStyle refStyle="al"/>
                                                                                                                        </defaultStyles>
                                                                                                                    <CSS value="color:#454545"/></style>
                                                                                                                </v2_axisLabels>
                                                                                                            </v2_ordinalAxis>
                                                                                                            <chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Date"><chartContents><chartTextItem><dataSource><dataItemValue refDataItem="Date"/></dataSource></chartTextItem></chartContents><style><dataFormat><dateFormat pattern="MM/dd"/></dataFormat></style></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
                                                                                                        <v2_topLeftAxis>
                                                                                                            <v2_combinationChartTypes>
                                                                                                                <v2_area lineAreaShape="smooth" seriesType="stacked">
                                                                                                                    <v2_solidPalette>
                                                                                                                        
                                                                                                                    <v2_solidPaletteEntries><v2_solidPaletteEntry><v2_fillEffect defaultColor="#336699">
																											<v2_solidColor color="#D1B3D9"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#0084e3">
																											<v2_solidColor transparency="0" color="#88B2D3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#000066">
																											<v2_solidColor color="#EBC4B6"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99CCFF">
																											<v2_solidColor color="#B8B8BF"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99AACC">
																											<v2_solidColor color="#9AD7CD"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#999999">
																											<v2_solidColor color="#FFB2C1"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#F3F3F3">
																											<v2_solidColor color="#FDCF9B"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E7E7E7">
																											<v2_solidColor color="#E7E7E7"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E3E9F3">
																											<v2_solidColor color="#E3E9F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#CCCCCC">
																											<v2_solidColor color="#CCCCCC"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry></v2_solidPaletteEntries></v2_solidPalette>
                                                                                                                    <!-- v2_solidPaletteRef ref=&amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;quot;gDefaultSolid&amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;quot;/ -->
                                                                                                                <chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="CPU Utilization"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_area>
                                                                                                            </v2_combinationChartTypes>
                                                                                                            <v2_axis>
                                                                                                                <v2_axisRange>
                                                                                                                    <v2_automaticRange/>
                                                                                                                </v2_axisRange>
                                                                                                                <v2_axisLabels>
                                                                                                                    <style>
                                                                                                                        <defaultStyles>
                                                                                                                            <defaultStyle refStyle="al"/>
                                                                                                                        </defaultStyles>
                                                                                                                    <CSS value="color:#454545"/><dataFormat><numberFormat pattern="###.##'%'"/></dataFormat></style>
                                                                                                                </v2_axisLabels>
                                                                                                                <v2_majorGridlines lineColor="#EEEEF0" lineWeight="0"/>
                                                                                                            </v2_axis>
                                                                                                        </v2_topLeftAxis>
                                                                                                        <style>
                                                                                                            <defaultStyles>
                                                                                                                <defaultStyle refStyle="ch"/>
                                                                                                            </defaultStyles>
                                                                                                            <CSS value="width:685px;height:175px;font-family:Arial"/></style>
                                                                                                        
                                                                                                        <XMLAttributes><XMLAttribute name="titlesExpanded" output="no" value="true"/></XMLAttributes><v2_notes><v2_note refQuery="Performance Trends - ETL"><v2_chartTextItems><v2_chartTextItem><dataSource><staticValue>No CPU Utilization Data Available</staticValue></dataSource></v2_chartTextItem></v2_chartTextItems><v2_constrainedPosition><v2_verticalPosition><v2_middle offset="0px"/></v2_verticalPosition><v2_horizontalPosition><v2_center offset="0px"/></v2_horizontalPosition><v2_positionAnchor><v2_relativeChart/></v2_positionAnchor></v2_constrainedPosition><style><CSS value="font-size:18px;font-family:Arial;font-weight:bold;color:#DBDBDB"/></style><conditionalRender refVariable="showLabel"><renderFor refVariableValue="1"/></conditionalRender></v2_note></v2_notes><masterDetailLinks><masterDetailLink><masterContext><dataItemContext refDataItem="Application"/></masterContext><detailContext><parameterContext parameter="sApp"/></detailContext></masterDetailLink></masterDetailLinks></v2_combinationChart></contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Memory Utilization</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue>(30 Day)</staticValue></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<v2_combinationChart maxHotspots="10000" name="Combination Chart7" refQuery="Performance Trends - ETL">
                                                                                                        <v2_combinationTypeTooltips/>
                                                                                                        <v2_commonAxis>
                                                                                                            <v2_ordinalAxis>
                                                                                                                <v2_axisLine lineColor="#E1E1E2" lineWeight="0"/>
                                                                                                                <v2_axisLabels>
                                                                                                                    <style>
                                                                                                                        <defaultStyles>
                                                                                                                            <defaultStyle refStyle="al"/>
                                                                                                                        </defaultStyles>
                                                                                                                    <CSS value="color:#454545"/></style>
                                                                                                                </v2_axisLabels>
                                                                                                            </v2_ordinalAxis>
                                                                                                            <chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Date"><chartContents><chartTextItem><dataSource><dataItemValue refDataItem="Date"/></dataSource></chartTextItem></chartContents><style><dataFormat><dateFormat pattern="MM/dd"/></dataFormat></style></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
                                                                                                        <v2_topLeftAxis>
                                                                                                            <v2_combinationChartTypes>
                                                                                                                <v2_area lineAreaShape="smooth" seriesType="stacked">
                                                                                                                    <v2_solidPalette>
                                                                                                                        
                                                                                                                    <v2_solidPaletteEntries><v2_solidPaletteEntry><v2_fillEffect defaultColor="#000066">
																											<v2_solidColor color="#EBC4B6"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#0084e3">
																											<v2_solidColor transparency="0" color="#88B2D3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99CCFF">
																											<v2_solidColor color="#B8B8BF"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#336699">
																											<v2_solidColor color="#D1B3D9"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99AACC">
																											<v2_solidColor color="#9AD7CD"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#999999">
																											<v2_solidColor color="#FFB2C1"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#F3F3F3">
																											<v2_solidColor color="#FDCF9B"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E7E7E7">
																											<v2_solidColor color="#E7E7E7"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E3E9F3">
																											<v2_solidColor color="#E3E9F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#CCCCCC">
																											<v2_solidColor color="#CCCCCC"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry></v2_solidPaletteEntries></v2_solidPalette>
                                                                                                                    <!-- v2_solidPaletteRef ref=&amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;quot;gDefaultSolid&amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;quot;/ -->
                                                                                                                <chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Memory Utilization"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_area>
                                                                                                            </v2_combinationChartTypes>
                                                                                                            <v2_axis>
                                                                                                                <v2_axisRange>
                                                                                                                    <v2_automaticRange/>
                                                                                                                </v2_axisRange>
                                                                                                                <v2_axisLabels>
                                                                                                                    <style>
                                                                                                                        <defaultStyles>
                                                                                                                            <defaultStyle refStyle="al"/>
                                                                                                                        </defaultStyles>
                                                                                                                    <CSS value="color:#454545"/><dataFormat><numberFormat pattern="###.##'%'"/></dataFormat></style>
                                                                                                                </v2_axisLabels>
                                                                                                                <v2_majorGridlines lineColor="#EEEEF0" lineWeight="0"/>
                                                                                                            </v2_axis>
                                                                                                        </v2_topLeftAxis>
                                                                                                        <style>
                                                                                                            <defaultStyles>
                                                                                                                <defaultStyle refStyle="ch"/>
                                                                                                            </defaultStyles>
                                                                                                            <CSS value="width:685px;height:175px;font-family:Arial"/></style>
                                                                                                        
                                                                                                        <XMLAttributes><XMLAttribute name="titlesExpanded" output="no" value="true"/></XMLAttributes><v2_notes><v2_note refQuery="Performance Trends - ETL"><v2_chartTextItems><v2_chartTextItem><dataSource><staticValue>No Memory Utilization Data Available</staticValue></dataSource></v2_chartTextItem></v2_chartTextItems><style><CSS value="font-family:Arial;font-size:18px;font-weight:bold;color:#DBDBDB"/></style><v2_constrainedPosition><v2_verticalPosition><v2_middle offset="0px"/></v2_verticalPosition><v2_horizontalPosition><v2_center offset="0px"/></v2_horizontalPosition><v2_positionAnchor><v2_relativeChart/></v2_positionAnchor></v2_constrainedPosition><conditionalRender refVariable="showLabel2"><renderFor refVariableValue="1"/></conditionalRender></v2_note></v2_notes><masterDetailLinks><masterDetailLink><masterContext><dataItemContext refDataItem="Application"/></masterContext><detailContext><parameterContext parameter="sApp"/></detailContext></masterDetailLink></masterDetailLinks></v2_combinationChart></contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-top:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding:5px 10px 10px 10px;background-color:#F7F7F7"/></style></tableCell></tableCells></tableRow></tableRows></table></contents></listColumnBody></listColumn></listColumns></list></contents>
						<style>
							<defaultStyles>
								<defaultStyle refStyle="sb"/>
							</defaultStyles>
						</style>
					</listColumnBody>
				</listColumn>
			</listColumns>
			
			
			
			<style>
				<CSS value="border-collapse:collapse; width:100%"/>
				<defaultStyles>
					<defaultStyle refStyle="sc"/>
				</defaultStyles>
			</style>
		<listGroups><listGroup refDataItem="Application"><listHeader><listRows><listRow><rowCells><rowCell><contents><textItem><dataSource><dataItemLabel refDataItem="Application"/></dataSource></textItem><textItem><dataSource><staticValue>: </staticValue></dataSource></textItem><textItem><dataSource><dataItemValue refDataItem="Application"/></dataSource></textItem></contents><style><defaultStyles><defaultStyle refStyle="sh"/></defaultStyles><CSS value="display:none"/></style></rowCell></rowCells></listRow></listRows></listHeader><XMLAttributes><XMLAttribute name="RS_SectionedEdge" value="columns" output="no"/></XMLAttributes></listGroup></listGroups><sectionsFrame refFrame="List1" sectionedEdge="columns"/><masterDetailLinks><masterDetailLink><masterContext><dataItemContext refDataItem="Application"/></masterContext><detailContext><dataItemContext refDataItem="Application"/></detailContext></masterDetailLink></masterDetailLinks></list></contents>
								</pageBody>
								
								<pageFooter>
									<contents>
										
									<table>
                                            <tableRows>
                                                <tableRow>
                                                    <tableCells>
                                                        <tableCell>
                                                            <contents>
                                                                
                                                            <image>
            <dataSource>
                <staticValue>../sanscreen/images/netapp_logo.png</staticValue>
            </dataSource>
        <style><CSS value="width:90px;height:36px"/></style></image></contents>
                                                            <style>
                                                                <CSS value="vertical-align:middle;text-align:left;width:30%"/>
                                                            </style>
                                                        </tableCell>
                                                        <tableCell>
                                                            <contents>
                                                                <textItem><dataSource><staticValue>Page </staticValue></dataSource></textItem><pageNumber/>
                                                            </contents>
                                                            <style>
                                                                <CSS value="vertical-align:middle;text-align:center;color:#9EA2A2;font-family:Helvetica;font-size:12px;width:40%"/>
                                                            </style>
                                                        </tableCell>
                                                        <tableCell>
                                                            <contents>
                                                                
                                                            <textItem><dataSource><staticValue>OnCommand Insight 7.3.  2014-18 NetApp.</staticValue></dataSource><style><CSS value="font-weight:normal"/></style></textItem></contents>
                                                            <style>
                                                                <CSS value="vertical-align:middle;text-align:right;width:30%;color:#9EA2A2;font-family:Arial;font-size:12px"/>
                                                            </style>
                                                        </tableCell>
                                                    </tableCells>
                                                </tableRow>
                                            </tableRows>
                                            <style>
                                                <defaultStyles>
                                                    <defaultStyle refStyle="tb"/>
                                                </defaultStyles>
                                                <CSS value="border-collapse:collapse;width:100%;height:32px"/>
                                            </style>
                                        </table></contents>
									<style>
										<defaultStyles>
											<defaultStyle refStyle="pf"/>
										</defaultStyles>
										<CSS value="padding-top:10px"/>
									</style>
								</pageFooter>
							<pageSetup orientation="portrait"><customPaper width="11" height="11" unit="in"/></pageSetup></page></detailPages>
		<pageGroups><pageGroup refDataItem="Application"/></pageGroups></pageSet></reportPages>
					<promptPages><page name="Prompt Page1">
			
			<pageBody>
				<contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Powered by OnCommand Insight</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:bold;color:white"/></style></textItem></contents><style><CSS value="height:24px;background-color:#6198C5;padding-left:10px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Application Capacity and Performance Trends with Forecast</staticValue></dataSource></textItem></contents><style><CSS value="height:36px;padding-left:10px;font-family:Arial;font-size:24px;color:#333333;background-color:#FBFBFB;border-bottom:1px solid #E1E1E2"/></style></tableCell></tableCells></tableRow></tableRows></table><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;margin-top:50px;margin-left:100px"/></style><tableRows><tableRow><tableCells><tableCell><contents/></tableCell><tableCell><contents><textItem><dataSource><staticValue>Select Application(s):</staticValue></dataSource><style><CSS value="font-size:16pt;color:gray"/></style></textItem></contents></tableCell><tableCell><contents/></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/></tableCell><tableCell><contents><selectValue parameter="sApp" refQuery="Application Prompt" required="false" multiSelect="true" selectValueUI="checkboxGroup"><useItem refDataItem="Application"/><style><CSS value="width:350px;height:550px"/></style></selectValue></contents></tableCell><tableCell><contents/></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/></tableCell><tableCell><contents/></tableCell><tableCell><contents/></tableCell></tableCells></tableRow></tableRows></table></contents>
				<style>
					<defaultStyles>
						<defaultStyle refStyle="py"/>
					</defaultStyles>
				</style>
			</pageBody>
			<pageFooter>
				<contents>
					<promptButton type="cancel">
						<contents/>
						<style>
							<defaultStyles>
								<defaultStyle refStyle="bp"/>
							</defaultStyles>
						</style>
					</promptButton>
					<promptButton type="back">
						<contents/>
						<style>
							<defaultStyles>
								<defaultStyle refStyle="bp"/>
							</defaultStyles>
						</style>
					</promptButton>
					<promptButton type="next">
						<contents/>
						<style>
							<defaultStyles>
								<defaultStyle refStyle="bp"/>
							</defaultStyles>
						</style>
					</promptButton>
					<promptButton type="finish">
						<contents/>
						<style>
							<defaultStyles>
								<defaultStyle refStyle="bp"/>
							</defaultStyles>
						</style>
					</promptButton>
				</contents>
				<style>
					<defaultStyles>
						<defaultStyle refStyle="fp"/>
					</defaultStyles>
				</style>
			</pageFooter>
			<style>
				<defaultStyles>
					<defaultStyle refStyle="pp"/>
				</defaultStyles>
			</style>
		</page></promptPages></layout>
				</layouts>
			<XMLAttributes><XMLAttribute name="RS_CreateExtendedDataItems" output="no" value="true"/><XMLAttribute name="listSeparator" output="no" value=","/><XMLAttribute name="RS_modelModificationTime" output="no" value="2017-11-15T20:33:46.811Z"/></XMLAttributes><reportName>4.8 Application Capacity and Performance Trends with Forecast - ETL</reportName><classStyles><classStyle name="freezeColumns" label="freezeColumns"/><classStyle name="freezeRows" label="freezeRows"/><classStyle name="freezeCorner" label="freezeCorner"/></classStyles><queries><query name="Application Forecast">
			<source>
				
			<sqlQuery name="SQL2" dataSource="dwh_capacity" type="passThrough">
			<sqlText>SELECT
appdata.application as 'Application',
appdata.appid as 'appid',
ROUND(SUM(appdata.AllocatedGB),2) as 'AllocatedGB',
ROUND(SUM(appdata.UsedGB),2) as 'UsedGB',
appdata.date as 'Date',
null as 'GrowthRate',
null as 'ProjectedAllocatedGB',
null as 'ProjectedUsedGB'

FROM
(
			SELECT 
			dwh_capacity.application_dimension.id as appid,
			dwh_capacity.application_dimension.name as application,
			ROUND(SUM(dwh_capacity.vm_capacity_fact.provisionedMB/1024),2) as AllocatedGB,
			ROUND(SUM(dwh_capacity.vm_capacity_fact.actualMB/1024),2) as UsedGB,
			dwh_capacity.date_dimension.fulldate as date
			
			FROM dwh_capacity.vm_capacity_Fact
			JOIN dwh_capacity.application_dimension
			ON   dwh_capacity.application_dimension.tk=dwh_capacity.vm_capacity_Fact.applicationtk
			AND  dwh_capacity.application_dimension.name&lt;&gt;'N/A'
			JOIN dwh_capacity.date_dimension
			ON   dwh_capacity.date_dimension.tk=dwh_capacity.vm_capacity_Fact.datetk
			AND  dwh_capacity.date_dimension.repmonthorlatest=1
			
			WHERE dwh_capacity.date_dimension.fullDate &gt;= (SELECT MAX(dwh_capacity.date_dimension.fullDate) 
                        FROM dwh_capacity.date_dimension JOIN dwh_capacity.vm_capacity_fact 
                        ON dwh_capacity.vm_capacity_fact.dateTk = dwh_capacity.date_dimension.tk) - INTERVAL 12 MONTH
                        
                        GROUP BY dwh_capacity.application_dimension.id, dwh_capacity.date_dimension.fulldate 
						
			UNION
			SELECT 	dwh_capacity.application_dimension.id appid,
				dwh_capacity.application_dimension.name application,
				ROUND(SUM(dwh_capacity.chargeback_fact.provisionedCapacityMB)/1024,2) as AllocatedGB,
				ROUND(SUM(dwh_capacity.chargeback_fact.usedCapacityMB)/1024,2) as UsedGB,
				dwh_capacity.date_dimension.fulldate as date
				
			FROM 	dwh_capacity.chargeback_fact
			JOIN 	dwh_capacity.application_dimension
			ON 	dwh_capacity.chargeback_fact.applicationTk = dwh_capacity.application_dimension.tk
			AND  dwh_capacity.application_dimension.name&lt;&gt;'N/A'
			AND 	dwh_capacity.chargeback_fact.mappedByVM = 0
			JOIN 	dwh_capacity.date_dimension
			ON 	dwh_capacity.chargeback_fact.dateTk = dwh_capacity.date_dimension.tk
			AND 	dwh_capacity.date_dimension.repmonthorlatest = 1
			
			WHERE dwh_capacity.date_dimension.fullDate &gt;= (SELECT MAX(dwh_capacity.date_dimension.fullDate) 
                        FROM dwh_capacity.date_dimension JOIN dwh_capacity.chargeback_fact 
                        ON dwh_capacity.chargeback_fact.dateTk = dwh_capacity.date_dimension.tk) - INTERVAL 12 MONTH
			
			
			GROUP BY dwh_capacity.application_dimension.id, dwh_capacity.date_dimension.fulldate
	) appdata
	
	GROUP BY appdata.appid, appdata.date

UNION

SELECT 
cag.application as 'Application',
cag.appid as 'appid',
null as 'AllocatedGB',
null as 'UsedGB',
apphistory.date as 'Date',
cag.growthrate as 'GrowthRate',
apphistory.AllocatedGB as 'ProjectedAllocatedGB',
apphistory.usedGB as 'ProjectedUsedGB'


FROM

(
SELECT
appdata2.appid as 'happid',
ROUND(SUM(appdata2.AllocatedGB),2) as 'AllocatedGB',
ROUND(SUM(appdata2.UsedGB),2) as 'UsedGB',
appdata2.date as 'Date'


FROM
(
			SELECT 
			dwh_capacity.application_dimension.id as appid,
			dwh_capacity.application_dimension.name as application,
			ROUND(SUM(dwh_capacity.vm_capacity_fact.provisionedMB/1024),2) as AllocatedGB,
			ROUND(SUM(dwh_capacity.vm_capacity_fact.actualMB/1024),2) as UsedGB,
			dwh_capacity.date_dimension.fulldate as date
			
			FROM dwh_capacity.vm_capacity_Fact
			JOIN dwh_capacity.application_dimension
			ON   dwh_capacity.application_dimension.tk=dwh_capacity.vm_capacity_Fact.applicationtk
			AND  dwh_capacity.application_dimension.name&lt;&gt;'N/A'
			JOIN dwh_capacity.date_dimension
			ON   dwh_capacity.date_dimension.tk=dwh_capacity.vm_capacity_Fact.datetk
						
			WHERE dwh_capacity.date_dimension.fullDate &gt;= (SELECT MAX(dwh_capacity.date_dimension.fullDate) 
                        FROM dwh_capacity.date_dimension JOIN dwh_capacity.vm_capacity_fact 
                        ON dwh_capacity.vm_capacity_fact.dateTk = dwh_capacity.date_dimension.tk) - INTERVAL 0 DAY
                        
                        GROUP BY dwh_capacity.application_dimension.id, dwh_capacity.date_dimension.fulldate 
						
			UNION
			SELECT 	dwh_capacity.application_dimension.id appid,
				dwh_capacity.application_dimension.name application,
				ROUND(SUM(dwh_capacity.chargeback_fact.provisionedCapacityMB)/1024,2) as AllocatedGB,
				ROUND(SUM(dwh_capacity.chargeback_fact.usedCapacityMB)/1024,2) as UsedGB,
				dwh_capacity.date_dimension.fulldate as date
				
			FROM 	dwh_capacity.chargeback_fact
			JOIN 	dwh_capacity.application_dimension
			ON 	dwh_capacity.chargeback_fact.applicationTk = dwh_capacity.application_dimension.tk
			AND  dwh_capacity.application_dimension.name&lt;&gt;'N/A'
			AND 	dwh_capacity.chargeback_fact.mappedByVM = 0
			JOIN 	dwh_capacity.date_dimension
			ON 	dwh_capacity.chargeback_fact.dateTk = dwh_capacity.date_dimension.tk
			
			
			WHERE dwh_capacity.date_dimension.fullDate &gt;= (SELECT MAX(dwh_capacity.date_dimension.fullDate) 
                        FROM dwh_capacity.date_dimension JOIN dwh_capacity.chargeback_fact 
                        ON dwh_capacity.chargeback_fact.dateTk = dwh_capacity.date_dimension.tk) - INTERVAL 0 DAY
			
			
			GROUP BY dwh_capacity.application_dimension.id, dwh_capacity.date_dimension.fulldate
	) appdata2
	
	GROUP BY appdata2.appid, appdata2.date

) apphistory



JOIN

(
SELECT
cagr.application as 'application',
cagr.appid as 'appid',
cagr.CAGR as 'GrowthRate',
cagr.DataPoints as DP

FROM
(
SELECT
IFNULL(end.application,begin.application) as 'application',
IFNULL(end.appid,begin.appid) as 'appid',
begin.BeginUsed,
begin.date as 'BeginDate',
end.EndUsed,
end.date as 'EndDate',

TIMESTAMPDIFF(MONTH,begin.date,end.date) as 'DataPoints',
power(end.EndUsed / begin.BeginUsed, 1/TIMESTAMPDIFF(MONTH,begin.date,end.date))-1 as 'CAGR'




FROM
(


SELECT
appdata2.application as 'application',
appdata2.appid as 'appid',
appdata2.UsedGB as 'EndUsed',
appdata2.date as 'Date'


FROM
(
			SELECT 
			dwh_capacity.application_dimension.id as appid,
			dwh_capacity.application_dimension.name as application,
			ROUND(SUM(dwh_capacity.vm_capacity_fact.provisionedMB/1024),2) as AllocatedGB,
			ROUND(SUM(dwh_capacity.vm_capacity_fact.actualMB/1024),2) as UsedGB,
			DATE_FORMAT(dwh_capacity.date_dimension.fulldate, '%Y-%m-%d') as date
			
			FROM dwh_capacity.vm_capacity_Fact
			JOIN dwh_capacity.application_dimension
			ON   dwh_capacity.application_dimension.tk=dwh_capacity.vm_capacity_Fact.applicationtk
			AND  dwh_capacity.application_dimension.name&lt;&gt;'N/A'
			JOIN dwh_capacity.date_dimension
			ON   dwh_capacity.date_dimension.tk=dwh_capacity.vm_capacity_Fact.datetk
						
			WHERE dwh_capacity.date_dimension.fullDate &gt;= (SELECT MAX(dwh_capacity.date_dimension.fullDate) 
                        FROM dwh_capacity.date_dimension JOIN dwh_capacity.vm_capacity_fact 
                        ON dwh_capacity.vm_capacity_fact.dateTk = dwh_capacity.date_dimension.tk) - INTERVAL 0 DAY
                        
                        GROUP BY dwh_capacity.application_dimension.id, dwh_capacity.date_dimension.fulldate 
						
			UNION
			SELECT 	dwh_capacity.application_dimension.id appid,
				dwh_capacity.application_dimension.name application,
				ROUND(SUM(dwh_capacity.chargeback_fact.provisionedCapacityMB)/1024,2) as AllocatedGB,
				ROUND(SUM(dwh_capacity.chargeback_fact.usedCapacityMB)/1024,2) as UsedGB,
				DATE_FORMAT(dwh_capacity.date_dimension.fulldate, '%Y-%m-%d') as date
				
			FROM 	dwh_capacity.chargeback_fact
			JOIN 	dwh_capacity.application_dimension
			ON 	dwh_capacity.chargeback_fact.applicationTk = dwh_capacity.application_dimension.tk
			AND  dwh_capacity.application_dimension.name&lt;&gt;'N/A'
			AND 	dwh_capacity.chargeback_fact.mappedByVM = 0
			JOIN 	dwh_capacity.date_dimension
			ON 	dwh_capacity.chargeback_fact.dateTk = dwh_capacity.date_dimension.tk
			
			
			WHERE dwh_capacity.date_dimension.fullDate &gt;= (SELECT MAX(dwh_capacity.date_dimension.fullDate) 
                        FROM dwh_capacity.date_dimension JOIN dwh_capacity.chargeback_fact 
                        ON dwh_capacity.chargeback_fact.dateTk = dwh_capacity.date_dimension.tk) - INTERVAL 0 DAY
			
			
			GROUP BY dwh_capacity.application_dimension.id, dwh_capacity.date_dimension.fulldate
	) appdata2
	
	GROUP BY appdata2.appid

) end

LEFT JOIN

(

SELECT
begincap.application,
begincap.appid,
begincap.BeginUsed,
begincap.Date

FROM(

SELECT
appdata2.application as 'application',
appdata2.appid as 'appid',
appdata2.UsedGB as 'BeginUsed',
appdata2.date as 'Date'


FROM
(
			SELECT 
			dwh_capacity.application_dimension.id as appid,
			dwh_capacity.application_dimension.name as application,
			ROUND(SUM(dwh_capacity.vm_capacity_fact.provisionedMB/1024),2) as AllocatedGB,
			ROUND(SUM(dwh_capacity.vm_capacity_fact.actualMB/1024),2) as UsedGB,
			DATE_FORMAT(dwh_capacity.date_dimension.fulldate, '%Y-%m-%d') as date
			
			FROM dwh_capacity.vm_capacity_Fact
			JOIN dwh_capacity.application_dimension
			ON   dwh_capacity.application_dimension.tk=dwh_capacity.vm_capacity_Fact.applicationtk
			AND  dwh_capacity.application_dimension.name&lt;&gt;'N/A'
			JOIN dwh_capacity.date_dimension
			ON   dwh_capacity.date_dimension.tk=dwh_capacity.vm_capacity_Fact.datetk
						
			WHERE dwh_capacity.date_dimension.fullDate BETWEEN (SELECT MAX(dwh_capacity.date_dimension.fullDate) 
                        FROM dwh_capacity.date_dimension JOIN dwh_capacity.vm_capacity_fact 
                        ON dwh_capacity.vm_capacity_fact.dateTk = dwh_capacity.date_dimension.tk) - INTERVAL 12 MONTH
				AND
				(SELECT MAX(dwh_capacity.date_dimension.fullDate) 
                        FROM dwh_capacity.date_dimension JOIN dwh_capacity.vm_capacity_fact 
                        ON dwh_capacity.vm_capacity_fact.dateTk = dwh_capacity.date_dimension.tk) - INTERVAL 12 MONTH
                        
                        
                        GROUP BY dwh_capacity.application_dimension.id, dwh_capacity.date_dimension.fulldate 
						
			UNION
			SELECT 	dwh_capacity.application_dimension.id appid,
				dwh_capacity.application_dimension.name application,
				ROUND(SUM(dwh_capacity.chargeback_fact.provisionedCapacityMB)/1024,2) as AllocatedGB,
				ROUND(SUM(dwh_capacity.chargeback_fact.usedCapacityMB)/1024,2) as UsedGB,
				DATE_FORMAT(dwh_capacity.date_dimension.fulldate, '%Y-%m-%d') as date
				
			FROM 	dwh_capacity.chargeback_fact
			JOIN 	dwh_capacity.application_dimension
			ON 	dwh_capacity.chargeback_fact.applicationTk = dwh_capacity.application_dimension.tk
			AND  dwh_capacity.application_dimension.name&lt;&gt;'N/A'
			AND 	dwh_capacity.chargeback_fact.mappedByVM = 0
			JOIN 	dwh_capacity.date_dimension
			ON 	dwh_capacity.chargeback_fact.dateTk = dwh_capacity.date_dimension.tk
			
			


			WHERE dwh_capacity.date_dimension.fullDate BETWEEN (SELECT MAX(dwh_capacity.date_dimension.fullDate) 
                        FROM dwh_capacity.date_dimension JOIN dwh_capacity.chargeback_fact 
                        ON dwh_capacity.chargeback_fact.dateTk = dwh_capacity.date_dimension.tk) - INTERVAL 12 MONTH
				AND
				(SELECT MAX(dwh_capacity.date_dimension.fullDate) 
                        FROM dwh_capacity.date_dimension JOIN dwh_capacity.chargeback_fact 
                        ON dwh_capacity.chargeback_fact.dateTk = dwh_capacity.date_dimension.tk) - INTERVAL 12 MONTH
						
			GROUP BY dwh_capacity.application_dimension.id, dwh_capacity.date_dimension.fulldate
	) appdata2
	
	GROUP BY appdata2.appid
) begincap
HAVING begincap.BeginUsed &gt; 0 

) begin ON begin.appid=end.appid

HAVING begin.BeginUsed is not null AND DataPoints &gt; 0


) cagr

 ) cag ON cag.appid=apphistory.happid 


/* Get First Month Growth Data */

UNION

SELECT 
cag.application as 'Application',
cag.appid as 'appid',
null as 'AllocatedGB',
null as 'UsedGB',
DATE_ADD(apphistory.date, INTERVAL 1 MONTH) as 'Date',
cag.growthrate as 'GrowthRate',
apphistory.AllocatedGB as 'ProjectedAllocatedGB',
(apphistory.usedGB*(1+cag.growthrate)) as 'ProjectedUsedGB'


FROM

(
SELECT
appdata2.appid as 'happid',
ROUND(SUM(appdata2.AllocatedGB),2) as 'AllocatedGB',
ROUND(SUM(appdata2.UsedGB),2) as 'UsedGB',
appdata2.date as 'Date'


FROM
(
			SELECT 
			dwh_capacity.application_dimension.id as appid,
			dwh_capacity.application_dimension.name as application,
			ROUND(SUM(dwh_capacity.vm_capacity_fact.provisionedMB/1024),2) as AllocatedGB,
			ROUND(SUM(dwh_capacity.vm_capacity_fact.actualMB/1024),2) as UsedGB,
			dwh_capacity.date_dimension.fulldate as date
			
			FROM dwh_capacity.vm_capacity_Fact
			JOIN dwh_capacity.application_dimension
			ON   dwh_capacity.application_dimension.tk=dwh_capacity.vm_capacity_Fact.applicationtk
			AND  dwh_capacity.application_dimension.name&lt;&gt;'N/A'
			JOIN dwh_capacity.date_dimension
			ON   dwh_capacity.date_dimension.tk=dwh_capacity.vm_capacity_Fact.datetk
						
			WHERE dwh_capacity.date_dimension.fullDate &gt;= (SELECT MAX(dwh_capacity.date_dimension.fullDate) 
                        FROM dwh_capacity.date_dimension JOIN dwh_capacity.vm_capacity_fact 
                        ON dwh_capacity.vm_capacity_fact.dateTk = dwh_capacity.date_dimension.tk) - INTERVAL 0 DAY
                        
                        GROUP BY dwh_capacity.application_dimension.id, dwh_capacity.date_dimension.fulldate 
						
			UNION
			SELECT 	dwh_capacity.application_dimension.id appid,
				dwh_capacity.application_dimension.name application,
				ROUND(SUM(dwh_capacity.chargeback_fact.provisionedCapacityMB)/1024,2) as AllocatedGB,
				ROUND(SUM(dwh_capacity.chargeback_fact.usedCapacityMB)/1024,2) as UsedGB,
				dwh_capacity.date_dimension.fulldate as date
				
			FROM 	dwh_capacity.chargeback_fact
			JOIN 	dwh_capacity.application_dimension
			ON 	dwh_capacity.chargeback_fact.applicationTk = dwh_capacity.application_dimension.tk
			AND  dwh_capacity.application_dimension.name&lt;&gt;'N/A'
			AND 	dwh_capacity.chargeback_fact.mappedByVM = 0
			JOIN 	dwh_capacity.date_dimension
			ON 	dwh_capacity.chargeback_fact.dateTk = dwh_capacity.date_dimension.tk
			
			
			WHERE dwh_capacity.date_dimension.fullDate &gt;= (SELECT MAX(dwh_capacity.date_dimension.fullDate) 
                        FROM dwh_capacity.date_dimension JOIN dwh_capacity.chargeback_fact 
                        ON dwh_capacity.chargeback_fact.dateTk = dwh_capacity.date_dimension.tk) - INTERVAL 0 DAY
			
			
			GROUP BY dwh_capacity.application_dimension.id, dwh_capacity.date_dimension.fulldate
	) appdata2
	
	GROUP BY appdata2.appid, appdata2.date

) apphistory



JOIN

(
SELECT
cagr.application as 'application',
cagr.appid as 'appid',
cagr.CAGR as 'GrowthRate'

FROM
(
SELECT
IFNULL(end.application,begin.application) as 'application',
IFNULL(end.appid,begin.appid) as 'appid',
begin.BeginUsed,
begin.date as 'BeginDate',
end.EndUsed,
end.date as 'EndDate',

TIMESTAMPDIFF(MONTH,begin.date,end.date) as 'DataPoints',

power(end.EndUsed / begin.BeginUsed, 1/TIMESTAMPDIFF(MONTH,begin.date,end.date))-1 as 'CAGR'

FROM
(


SELECT
appdata2.application as 'application',
appdata2.appid as 'appid',
appdata2.UsedGB as 'EndUsed',
appdata2.date as 'Date'


FROM
(
			SELECT 
			dwh_capacity.application_dimension.id as appid,
			dwh_capacity.application_dimension.name as application,
			ROUND(SUM(dwh_capacity.vm_capacity_fact.provisionedMB/1024),2) as AllocatedGB,
			ROUND(SUM(dwh_capacity.vm_capacity_fact.actualMB/1024),2) as UsedGB,
			DATE_FORMAT(dwh_capacity.date_dimension.fulldate, '%Y-%m-%d') as date
			
			FROM dwh_capacity.vm_capacity_Fact
			JOIN dwh_capacity.application_dimension
			ON   dwh_capacity.application_dimension.tk=dwh_capacity.vm_capacity_Fact.applicationtk
			AND  dwh_capacity.application_dimension.name&lt;&gt;'N/A'
			JOIN dwh_capacity.date_dimension
			ON   dwh_capacity.date_dimension.tk=dwh_capacity.vm_capacity_Fact.datetk
						
			WHERE dwh_capacity.date_dimension.fullDate &gt;= (SELECT MAX(dwh_capacity.date_dimension.fullDate) 
                        FROM dwh_capacity.date_dimension JOIN dwh_capacity.vm_capacity_fact 
                        ON dwh_capacity.vm_capacity_fact.dateTk = dwh_capacity.date_dimension.tk) - INTERVAL 0 DAY
                        
                        GROUP BY dwh_capacity.application_dimension.id, dwh_capacity.date_dimension.fulldate 
						
			UNION
			SELECT 	dwh_capacity.application_dimension.id appid,
				dwh_capacity.application_dimension.name application,
				ROUND(SUM(dwh_capacity.chargeback_fact.provisionedCapacityMB)/1024,2) as AllocatedGB,
				ROUND(SUM(dwh_capacity.chargeback_fact.usedCapacityMB)/1024,2) as UsedGB,
				DATE_FORMAT(dwh_capacity.date_dimension.fulldate, '%Y-%m-%d') as date
				
			FROM 	dwh_capacity.chargeback_fact
			JOIN 	dwh_capacity.application_dimension
			ON 	dwh_capacity.chargeback_fact.applicationTk = dwh_capacity.application_dimension.tk
			AND  dwh_capacity.application_dimension.name&lt;&gt;'N/A'
			AND 	dwh_capacity.chargeback_fact.mappedByVM = 0
			JOIN 	dwh_capacity.date_dimension
			ON 	dwh_capacity.chargeback_fact.dateTk = dwh_capacity.date_dimension.tk
			
			
			WHERE dwh_capacity.date_dimension.fullDate &gt;= (SELECT MAX(dwh_capacity.date_dimension.fullDate) 
                        FROM dwh_capacity.date_dimension JOIN dwh_capacity.chargeback_fact 
                        ON dwh_capacity.chargeback_fact.dateTk = dwh_capacity.date_dimension.tk) - INTERVAL 0 DAY
			
			
			GROUP BY dwh_capacity.application_dimension.id, dwh_capacity.date_dimension.fulldate
	) appdata2
	
	GROUP BY appdata2.appid

) end

LEFT JOIN

(

SELECT
begincap.application,
begincap.appid,
begincap.BeginUsed,
begincap.Date

FROM(

SELECT
appdata2.application as 'application',
appdata2.appid as 'appid',
appdata2.UsedGB as 'BeginUsed',
appdata2.date as 'Date'


FROM
(
			SELECT 
			dwh_capacity.application_dimension.id as appid,
			dwh_capacity.application_dimension.name as application,
			ROUND(SUM(dwh_capacity.vm_capacity_fact.provisionedMB/1024),2) as AllocatedGB,
			ROUND(SUM(dwh_capacity.vm_capacity_fact.actualMB/1024),2) as UsedGB,
			DATE_FORMAT(dwh_capacity.date_dimension.fulldate, '%Y-%m-%d') as date
			
			FROM dwh_capacity.vm_capacity_Fact
			JOIN dwh_capacity.application_dimension
			ON   dwh_capacity.application_dimension.tk=dwh_capacity.vm_capacity_Fact.applicationtk
			AND  dwh_capacity.application_dimension.name&lt;&gt;'N/A'
			JOIN dwh_capacity.date_dimension
			ON   dwh_capacity.date_dimension.tk=dwh_capacity.vm_capacity_Fact.datetk
			
			WHERE dwh_capacity.date_dimension.fullDate BETWEEN (SELECT MAX(dwh_capacity.date_dimension.fullDate) 
                        FROM dwh_capacity.date_dimension JOIN dwh_capacity.vm_capacity_fact 
                        ON dwh_capacity.vm_capacity_fact.dateTk = dwh_capacity.date_dimension.tk) - INTERVAL 12 MONTH
				AND
				(SELECT MAX(dwh_capacity.date_dimension.fullDate) 
                        FROM dwh_capacity.date_dimension JOIN dwh_capacity.vm_capacity_fact 
                        ON dwh_capacity.vm_capacity_fact.dateTk = dwh_capacity.date_dimension.tk) - INTERVAL 12 MONTH
                        
                        
                        GROUP BY dwh_capacity.application_dimension.id, dwh_capacity.date_dimension.fulldate 
						
			UNION
			SELECT 	dwh_capacity.application_dimension.id appid,
				dwh_capacity.application_dimension.name application,
				ROUND(SUM(dwh_capacity.chargeback_fact.provisionedCapacityMB)/1024,2) as AllocatedGB,
				ROUND(SUM(dwh_capacity.chargeback_fact.usedCapacityMB)/1024,2) as UsedGB,
				DATE_FORMAT(dwh_capacity.date_dimension.fulldate, '%Y-%m-%d') as date
				
			FROM 	dwh_capacity.chargeback_fact
			JOIN 	dwh_capacity.application_dimension
			ON 	dwh_capacity.chargeback_fact.applicationTk = dwh_capacity.application_dimension.tk
			AND  dwh_capacity.application_dimension.name&lt;&gt;'N/A'
			AND 	dwh_capacity.chargeback_fact.mappedByVM = 0
			JOIN 	dwh_capacity.date_dimension
			ON 	dwh_capacity.chargeback_fact.dateTk = dwh_capacity.date_dimension.tk
			
			
			WHERE dwh_capacity.date_dimension.fullDate BETWEEN (SELECT MAX(dwh_capacity.date_dimension.fullDate) 
                        FROM dwh_capacity.date_dimension JOIN dwh_capacity.chargeback_fact 
                        ON dwh_capacity.chargeback_fact.dateTk = dwh_capacity.date_dimension.tk) - INTERVAL 12 MONTH
				AND
				(SELECT MAX(dwh_capacity.date_dimension.fullDate) 
                        FROM dwh_capacity.date_dimension JOIN dwh_capacity.chargeback_fact 
                        ON dwh_capacity.chargeback_fact.dateTk = dwh_capacity.date_dimension.tk) - INTERVAL 12 MONTH
						
			GROUP BY dwh_capacity.application_dimension.id, dwh_capacity.date_dimension.fulldate
	) appdata2
	
	GROUP BY appdata2.appid
) begincap
HAVING begincap.BeginUsed &gt; 0 

) begin ON begin.appid=end.appid

HAVING begin.BeginUsed is not null AND DataPoints &gt; 0


) cagr

 ) cag ON cag.appid=apphistory.happid 



/* Get 2nd Month Growth Data */

UNION


SELECT 
cag.application as 'Application',
cag.appid as 'appid',
null as 'AllocatedGB',
null as 'UsedGB',
DATE_ADD(apphistory.date, INTERVAL 2 MONTH) as 'Date',
cag.growthrate as 'GrowthRate',
apphistory.AllocatedGB as 'ProjectedAllocatedGB',
(apphistory.usedGB*(cag.growthrate*2))+apphistory.usedGB as 'ProjectedUsedGB'


FROM

(
SELECT
appdata2.appid as 'happid',
ROUND(SUM(appdata2.AllocatedGB),2) as 'AllocatedGB',
ROUND(SUM(appdata2.UsedGB),2) as 'UsedGB',
appdata2.date as 'Date'


FROM
(
			SELECT 
			dwh_capacity.application_dimension.id as appid,
			dwh_capacity.application_dimension.name as application,
			ROUND(SUM(dwh_capacity.vm_capacity_fact.provisionedMB/1024),2) as AllocatedGB,
			ROUND(SUM(dwh_capacity.vm_capacity_fact.actualMB/1024),2) as UsedGB,
			dwh_capacity.date_dimension.fulldate as date
			
			FROM dwh_capacity.vm_capacity_Fact
			JOIN dwh_capacity.application_dimension
			ON   dwh_capacity.application_dimension.tk=dwh_capacity.vm_capacity_Fact.applicationtk
			AND  dwh_capacity.application_dimension.name&lt;&gt;'N/A'
			JOIN dwh_capacity.date_dimension
			ON   dwh_capacity.date_dimension.tk=dwh_capacity.vm_capacity_Fact.datetk
						
			WHERE dwh_capacity.date_dimension.fullDate &gt;= (SELECT MAX(dwh_capacity.date_dimension.fullDate) 
                        FROM dwh_capacity.date_dimension JOIN dwh_capacity.vm_capacity_fact 
                        ON dwh_capacity.vm_capacity_fact.dateTk = dwh_capacity.date_dimension.tk) - INTERVAL 0 DAY
                        
                        GROUP BY dwh_capacity.application_dimension.id, dwh_capacity.date_dimension.fulldate 
						
			UNION
			SELECT 	dwh_capacity.application_dimension.id appid,
				dwh_capacity.application_dimension.name application,
				ROUND(SUM(dwh_capacity.chargeback_fact.provisionedCapacityMB)/1024,2) as AllocatedGB,
				ROUND(SUM(dwh_capacity.chargeback_fact.usedCapacityMB)/1024,2) as UsedGB,
				dwh_capacity.date_dimension.fulldate as date
				
			FROM 	dwh_capacity.chargeback_fact
			JOIN 	dwh_capacity.application_dimension
			ON 	dwh_capacity.chargeback_fact.applicationTk = dwh_capacity.application_dimension.tk
			AND  dwh_capacity.application_dimension.name&lt;&gt;'N/A'
			AND 	dwh_capacity.chargeback_fact.mappedByVM = 0
			JOIN 	dwh_capacity.date_dimension
			ON 	dwh_capacity.chargeback_fact.dateTk = dwh_capacity.date_dimension.tk
			
			
			WHERE dwh_capacity.date_dimension.fullDate &gt;= (SELECT MAX(dwh_capacity.date_dimension.fullDate) 
                        FROM dwh_capacity.date_dimension JOIN dwh_capacity.chargeback_fact 
                        ON dwh_capacity.chargeback_fact.dateTk = dwh_capacity.date_dimension.tk) - INTERVAL 0 DAY
			
			
			GROUP BY dwh_capacity.application_dimension.id, dwh_capacity.date_dimension.fulldate
	) appdata2
	
	GROUP BY appdata2.appid, appdata2.date

) apphistory



JOIN

(
SELECT
cagr.application as 'application',
cagr.appid as 'appid',
cagr.CAGR as 'GrowthRate'

FROM
(
SELECT
IFNULL(end.application,begin.application) as 'application',
IFNULL(end.appid,begin.appid) as 'appid',
begin.BeginUsed,
begin.date as 'BeginDate',
end.EndUsed,
end.date as 'EndDate',

TIMESTAMPDIFF(MONTH,begin.date,end.date) as 'DataPoints',

power(end.EndUsed / begin.BeginUsed, 1/TIMESTAMPDIFF(MONTH,begin.date,end.date))-1 as 'CAGR'

FROM
(


SELECT
appdata2.application as 'application',
appdata2.appid as 'appid',
appdata2.UsedGB as 'EndUsed',
appdata2.date as 'Date'


FROM
(
			SELECT 
			dwh_capacity.application_dimension.id as appid,
			dwh_capacity.application_dimension.name as application,
			ROUND(SUM(dwh_capacity.vm_capacity_fact.provisionedMB/1024),2) as AllocatedGB,
			ROUND(SUM(dwh_capacity.vm_capacity_fact.actualMB/1024),2) as UsedGB,
			DATE_FORMAT(dwh_capacity.date_dimension.fulldate, '%Y-%m-%d') as date
			
			FROM dwh_capacity.vm_capacity_Fact
			JOIN dwh_capacity.application_dimension
			ON   dwh_capacity.application_dimension.tk=dwh_capacity.vm_capacity_Fact.applicationtk
			AND  dwh_capacity.application_dimension.name&lt;&gt;'N/A'
			JOIN dwh_capacity.date_dimension
			ON   dwh_capacity.date_dimension.tk=dwh_capacity.vm_capacity_Fact.datetk
						
			WHERE dwh_capacity.date_dimension.fullDate &gt;= (SELECT MAX(dwh_capacity.date_dimension.fullDate) 
                        FROM dwh_capacity.date_dimension JOIN dwh_capacity.vm_capacity_fact 
                        ON dwh_capacity.vm_capacity_fact.dateTk = dwh_capacity.date_dimension.tk) - INTERVAL 0 DAY
                        
                        GROUP BY dwh_capacity.application_dimension.id, dwh_capacity.date_dimension.fulldate 
						
			UNION
			SELECT 	dwh_capacity.application_dimension.id appid,
				dwh_capacity.application_dimension.name application,
				ROUND(SUM(dwh_capacity.chargeback_fact.provisionedCapacityMB)/1024,2) as AllocatedGB,
				ROUND(SUM(dwh_capacity.chargeback_fact.usedCapacityMB)/1024,2) as UsedGB,
				DATE_FORMAT(dwh_capacity.date_dimension.fulldate, '%Y-%m-%d') as date
				
			FROM 	dwh_capacity.chargeback_fact
			JOIN 	dwh_capacity.application_dimension
			ON 	dwh_capacity.chargeback_fact.applicationTk = dwh_capacity.application_dimension.tk
			AND  dwh_capacity.application_dimension.name&lt;&gt;'N/A'
			AND 	dwh_capacity.chargeback_fact.mappedByVM = 0
			JOIN 	dwh_capacity.date_dimension
			ON 	dwh_capacity.chargeback_fact.dateTk = dwh_capacity.date_dimension.tk
			
			
			WHERE dwh_capacity.date_dimension.fullDate &gt;= (SELECT MAX(dwh_capacity.date_dimension.fullDate) 
                        FROM dwh_capacity.date_dimension JOIN dwh_capacity.chargeback_fact 
                        ON dwh_capacity.chargeback_fact.dateTk = dwh_capacity.date_dimension.tk) - INTERVAL 0 DAY
			
			
			GROUP BY dwh_capacity.application_dimension.id, dwh_capacity.date_dimension.fulldate
	) appdata2
	
	GROUP BY appdata2.appid

) end

LEFT JOIN

(

SELECT
begincap.application,
begincap.appid,
begincap.BeginUsed,
begincap.Date

FROM(

SELECT
appdata2.application as 'application',
appdata2.appid as 'appid',
appdata2.UsedGB as 'BeginUsed',
appdata2.date as 'Date'


FROM
(
			SELECT 
			dwh_capacity.application_dimension.id as appid,
			dwh_capacity.application_dimension.name as application,
			ROUND(SUM(dwh_capacity.vm_capacity_fact.provisionedMB/1024),2) as AllocatedGB,
			ROUND(SUM(dwh_capacity.vm_capacity_fact.actualMB/1024),2) as UsedGB,
			DATE_FORMAT(dwh_capacity.date_dimension.fulldate, '%Y-%m-%d') as date
			
			FROM dwh_capacity.vm_capacity_Fact
			JOIN dwh_capacity.application_dimension
			ON   dwh_capacity.application_dimension.tk=dwh_capacity.vm_capacity_Fact.applicationtk
			AND  dwh_capacity.application_dimension.name&lt;&gt;'N/A'
			JOIN dwh_capacity.date_dimension
			ON   dwh_capacity.date_dimension.tk=dwh_capacity.vm_capacity_Fact.datetk
			
			WHERE dwh_capacity.date_dimension.fullDate BETWEEN (SELECT MAX(dwh_capacity.date_dimension.fullDate) 
                        FROM dwh_capacity.date_dimension JOIN dwh_capacity.vm_capacity_fact 
                        ON dwh_capacity.vm_capacity_fact.dateTk = dwh_capacity.date_dimension.tk) - INTERVAL 12 MONTH
				AND
				(SELECT MAX(dwh_capacity.date_dimension.fullDate) 
                        FROM dwh_capacity.date_dimension JOIN dwh_capacity.vm_capacity_fact 
                        ON dwh_capacity.vm_capacity_fact.dateTk = dwh_capacity.date_dimension.tk) - INTERVAL 12 MONTH
                        
                        
                        GROUP BY dwh_capacity.application_dimension.id, dwh_capacity.date_dimension.fulldate 
						
			UNION
			SELECT 	dwh_capacity.application_dimension.id appid,
				dwh_capacity.application_dimension.name application,
				ROUND(SUM(dwh_capacity.chargeback_fact.provisionedCapacityMB)/1024,2) as AllocatedGB,
				ROUND(SUM(dwh_capacity.chargeback_fact.usedCapacityMB)/1024,2) as UsedGB,
				DATE_FORMAT(dwh_capacity.date_dimension.fulldate, '%Y-%m-%d') as date
				
			FROM 	dwh_capacity.chargeback_fact
			JOIN 	dwh_capacity.application_dimension
			ON 	dwh_capacity.chargeback_fact.applicationTk = dwh_capacity.application_dimension.tk
			AND  dwh_capacity.application_dimension.name&lt;&gt;'N/A'
			AND 	dwh_capacity.chargeback_fact.mappedByVM = 0
			JOIN 	dwh_capacity.date_dimension
			ON 	dwh_capacity.chargeback_fact.dateTk = dwh_capacity.date_dimension.tk
			
			
			WHERE dwh_capacity.date_dimension.fullDate BETWEEN (SELECT MAX(dwh_capacity.date_dimension.fullDate) 
                        FROM dwh_capacity.date_dimension JOIN dwh_capacity.chargeback_fact 
                        ON dwh_capacity.chargeback_fact.dateTk = dwh_capacity.date_dimension.tk) - INTERVAL 12 MONTH
				AND
			(SELECT MAX(dwh_capacity.date_dimension.fullDate) 
                        FROM dwh_capacity.date_dimension JOIN dwh_capacity.chargeback_fact 
                        ON dwh_capacity.chargeback_fact.dateTk = dwh_capacity.date_dimension.tk) - INTERVAL 12 MONTH
						
			GROUP BY dwh_capacity.application_dimension.id, dwh_capacity.date_dimension.fulldate
	) appdata2
	
	GROUP BY appdata2.appid
) begincap
HAVING begincap.BeginUsed &gt; 0 

) begin ON begin.appid=end.appid

HAVING begin.BeginUsed is not null AND DataPoints &gt; 0


) cagr

 ) cag ON cag.appid=apphistory.happid 



/* Get 3rd Month Future Data */

UNION


SELECT 
cag.application as 'Application',
cag.appid as 'appid',
null as 'AllocatedGB',
null as 'UsedGB',
DATE_ADD(apphistory.date, INTERVAL 3 MONTH) as 'Date',
cag.growthrate as 'GrowthRate',
apphistory.AllocatedGB as 'ProjectedAllocatedGB',
(apphistory.usedGB*(cag.growthrate*3))+apphistory.usedGB as 'ProjectedUsedGB'


FROM

(
SELECT
appdata2.appid as 'happid',
ROUND(SUM(appdata2.AllocatedGB),2) as 'AllocatedGB',
ROUND(SUM(appdata2.UsedGB),2) as 'UsedGB',
appdata2.date as 'Date'


FROM
(
			SELECT 
			dwh_capacity.application_dimension.id as appid,
			dwh_capacity.application_dimension.name as application,
			ROUND(SUM(dwh_capacity.vm_capacity_fact.provisionedMB/1024),2) as AllocatedGB,
			ROUND(SUM(dwh_capacity.vm_capacity_fact.actualMB/1024),2) as UsedGB,
			dwh_capacity.date_dimension.fulldate as date
			
			FROM dwh_capacity.vm_capacity_Fact
			JOIN dwh_capacity.application_dimension
			ON   dwh_capacity.application_dimension.tk=dwh_capacity.vm_capacity_Fact.applicationtk
			AND  dwh_capacity.application_dimension.name&lt;&gt;'N/A'
			JOIN dwh_capacity.date_dimension
			ON   dwh_capacity.date_dimension.tk=dwh_capacity.vm_capacity_Fact.datetk
						
			WHERE dwh_capacity.date_dimension.fullDate &gt;= (SELECT MAX(dwh_capacity.date_dimension.fullDate) 
                        FROM dwh_capacity.date_dimension JOIN dwh_capacity.vm_capacity_fact 
                        ON dwh_capacity.vm_capacity_fact.dateTk = dwh_capacity.date_dimension.tk) - INTERVAL 0 DAY
                        
                        GROUP BY dwh_capacity.application_dimension.id, dwh_capacity.date_dimension.fulldate 
						
			UNION
			SELECT 	dwh_capacity.application_dimension.id appid,
				dwh_capacity.application_dimension.name application,
				ROUND(SUM(dwh_capacity.chargeback_fact.provisionedCapacityMB)/1024,2) as AllocatedGB,
				ROUND(SUM(dwh_capacity.chargeback_fact.usedCapacityMB)/1024,2) as UsedGB,
				dwh_capacity.date_dimension.fulldate as date
				
			FROM 	dwh_capacity.chargeback_fact
			JOIN 	dwh_capacity.application_dimension
			ON 	dwh_capacity.chargeback_fact.applicationTk = dwh_capacity.application_dimension.tk
			AND  dwh_capacity.application_dimension.name&lt;&gt;'N/A'
			AND 	dwh_capacity.chargeback_fact.mappedByVM = 0
			JOIN 	dwh_capacity.date_dimension
			ON 	dwh_capacity.chargeback_fact.dateTk = dwh_capacity.date_dimension.tk
			
			
			WHERE dwh_capacity.date_dimension.fullDate &gt;= (SELECT MAX(dwh_capacity.date_dimension.fullDate) 
                        FROM dwh_capacity.date_dimension JOIN dwh_capacity.chargeback_fact 
                        ON dwh_capacity.chargeback_fact.dateTk = dwh_capacity.date_dimension.tk) - INTERVAL 0 DAY
			
			
			GROUP BY dwh_capacity.application_dimension.id, dwh_capacity.date_dimension.fulldate
	) appdata2
	
	GROUP BY appdata2.appid, appdata2.date

) apphistory



JOIN

(
SELECT
cagr.application as 'application',
cagr.appid as 'appid',
cagr.CAGR as 'GrowthRate'

FROM
(
SELECT
IFNULL(end.application,begin.application) as 'application',
IFNULL(end.appid,begin.appid) as 'appid',
begin.BeginUsed,
begin.date as 'BeginDate',
end.EndUsed,
end.date as 'EndDate',

TIMESTAMPDIFF(MONTH,begin.date,end.date) as 'DataPoints',

power(end.EndUsed / begin.BeginUsed, 1/TIMESTAMPDIFF(MONTH,begin.date,end.date))-1 as 'CAGR'

FROM
(


SELECT
appdata2.application as 'application',
appdata2.appid as 'appid',
appdata2.UsedGB as 'EndUsed',
appdata2.date as 'Date'


FROM
(
			SELECT 
			dwh_capacity.application_dimension.id as appid,
			dwh_capacity.application_dimension.name as application,
			ROUND(SUM(dwh_capacity.vm_capacity_fact.provisionedMB/1024),2) as AllocatedGB,
			ROUND(SUM(dwh_capacity.vm_capacity_fact.actualMB/1024),2) as UsedGB,
			DATE_FORMAT(dwh_capacity.date_dimension.fulldate, '%Y-%m-%d') as date
			
			FROM dwh_capacity.vm_capacity_Fact
			JOIN dwh_capacity.application_dimension
			ON   dwh_capacity.application_dimension.tk=dwh_capacity.vm_capacity_Fact.applicationtk
			AND  dwh_capacity.application_dimension.name&lt;&gt;'N/A'
			JOIN dwh_capacity.date_dimension
			ON   dwh_capacity.date_dimension.tk=dwh_capacity.vm_capacity_Fact.datetk
						
			WHERE dwh_capacity.date_dimension.fullDate &gt;= (SELECT MAX(dwh_capacity.date_dimension.fullDate) 
                        FROM dwh_capacity.date_dimension JOIN dwh_capacity.vm_capacity_fact 
                        ON dwh_capacity.vm_capacity_fact.dateTk = dwh_capacity.date_dimension.tk) - INTERVAL 0 DAY
                        
                        GROUP BY dwh_capacity.application_dimension.id, dwh_capacity.date_dimension.fulldate 
						
			UNION
			SELECT 	dwh_capacity.application_dimension.id appid,
				dwh_capacity.application_dimension.name application,
				ROUND(SUM(dwh_capacity.chargeback_fact.provisionedCapacityMB)/1024,2) as AllocatedGB,
				ROUND(SUM(dwh_capacity.chargeback_fact.usedCapacityMB)/1024,2) as UsedGB,
				DATE_FORMAT(dwh_capacity.date_dimension.fulldate, '%Y-%m-%d') as date
				
			FROM 	dwh_capacity.chargeback_fact
			JOIN 	dwh_capacity.application_dimension
			ON 	dwh_capacity.chargeback_fact.applicationTk = dwh_capacity.application_dimension.tk
			AND  dwh_capacity.application_dimension.name&lt;&gt;'N/A'
			AND 	dwh_capacity.chargeback_fact.mappedByVM = 0
			JOIN 	dwh_capacity.date_dimension
			ON 	dwh_capacity.chargeback_fact.dateTk = dwh_capacity.date_dimension.tk
			
			
			WHERE dwh_capacity.date_dimension.fullDate &gt;= (SELECT MAX(dwh_capacity.date_dimension.fullDate) 
                        FROM dwh_capacity.date_dimension JOIN dwh_capacity.chargeback_fact 
                        ON dwh_capacity.chargeback_fact.dateTk = dwh_capacity.date_dimension.tk) - INTERVAL 0 DAY
			
			
			GROUP BY dwh_capacity.application_dimension.id, dwh_capacity.date_dimension.fulldate
	) appdata2
	
	GROUP BY appdata2.appid

) end

LEFT JOIN

(

SELECT
begincap.application,
begincap.appid,
begincap.BeginUsed,
begincap.Date

FROM(

SELECT
appdata2.application as 'application',
appdata2.appid as 'appid',
appdata2.UsedGB as 'BeginUsed',
appdata2.date as 'Date'


FROM
(
			SELECT 
			dwh_capacity.application_dimension.id as appid,
			dwh_capacity.application_dimension.name as application,
			ROUND(SUM(dwh_capacity.vm_capacity_fact.provisionedMB/1024),2) as AllocatedGB,
			ROUND(SUM(dwh_capacity.vm_capacity_fact.actualMB/1024),2) as UsedGB,
			DATE_FORMAT(dwh_capacity.date_dimension.fulldate, '%Y-%m-%d') as date
			
			FROM dwh_capacity.vm_capacity_Fact
			JOIN dwh_capacity.application_dimension
			ON   dwh_capacity.application_dimension.tk=dwh_capacity.vm_capacity_Fact.applicationtk
			AND  dwh_capacity.application_dimension.name&lt;&gt;'N/A'
			JOIN dwh_capacity.date_dimension
			ON   dwh_capacity.date_dimension.tk=dwh_capacity.vm_capacity_Fact.datetk
			
			WHERE dwh_capacity.date_dimension.fullDate BETWEEN (SELECT MAX(dwh_capacity.date_dimension.fullDate) 
                        FROM dwh_capacity.date_dimension JOIN dwh_capacity.vm_capacity_fact 
                        ON dwh_capacity.vm_capacity_fact.dateTk = dwh_capacity.date_dimension.tk) - INTERVAL 12 MONTH
				AND
				(SELECT MAX(dwh_capacity.date_dimension.fullDate) 
                        FROM dwh_capacity.date_dimension JOIN dwh_capacity.vm_capacity_fact 
                        ON dwh_capacity.vm_capacity_fact.dateTk = dwh_capacity.date_dimension.tk) - INTERVAL 12 MONTH
                        
                        
                        GROUP BY dwh_capacity.application_dimension.id, dwh_capacity.date_dimension.fulldate 
						
			UNION
			SELECT 	dwh_capacity.application_dimension.id appid,
				dwh_capacity.application_dimension.name application,
				ROUND(SUM(dwh_capacity.chargeback_fact.provisionedCapacityMB)/1024,2) as AllocatedGB,
				ROUND(SUM(dwh_capacity.chargeback_fact.usedCapacityMB)/1024,2) as UsedGB,
				DATE_FORMAT(dwh_capacity.date_dimension.fulldate, '%Y-%m-%d') as date
				
			FROM 	dwh_capacity.chargeback_fact
			JOIN 	dwh_capacity.application_dimension
			ON 	dwh_capacity.chargeback_fact.applicationTk = dwh_capacity.application_dimension.tk
			AND  dwh_capacity.application_dimension.name&lt;&gt;'N/A'
			AND 	dwh_capacity.chargeback_fact.mappedByVM = 0
			JOIN 	dwh_capacity.date_dimension
			ON 	dwh_capacity.chargeback_fact.dateTk = dwh_capacity.date_dimension.tk
			
			
			WHERE dwh_capacity.date_dimension.fullDate BETWEEN (SELECT MAX(dwh_capacity.date_dimension.fullDate) 
                        FROM dwh_capacity.date_dimension JOIN dwh_capacity.chargeback_fact 
                        ON dwh_capacity.chargeback_fact.dateTk = dwh_capacity.date_dimension.tk) - INTERVAL 12 MONTH
				AND
			(SELECT MAX(dwh_capacity.date_dimension.fullDate) 
                        FROM dwh_capacity.date_dimension JOIN dwh_capacity.chargeback_fact 
                        ON dwh_capacity.chargeback_fact.dateTk = dwh_capacity.date_dimension.tk) - INTERVAL 12 MONTH
						
			GROUP BY dwh_capacity.application_dimension.id, dwh_capacity.date_dimension.fulldate
	) appdata2
	
	GROUP BY appdata2.appid
) begincap
HAVING begincap.BeginUsed &gt; 0 

) begin ON begin.appid=end.appid

HAVING begin.BeginUsed is not null AND DataPoints &gt; 0


) cagr

 ) cag ON cag.appid=apphistory.happid 



/* Get 4th Month Future Data */

UNION


SELECT 
cag.application as 'Application',
cag.appid as 'appid',
null as 'AllocatedGB',
null as 'UsedGB',
DATE_ADD(apphistory.date, INTERVAL 4 MONTH) as 'Date',
cag.growthrate as 'GrowthRate',
apphistory.AllocatedGB as 'ProjectedAllocatedGB',
(apphistory.usedGB*(cag.growthrate*4))+apphistory.usedGB as 'ProjectedUsedGB'


FROM

(
SELECT
appdata2.appid as 'happid',
ROUND(SUM(appdata2.AllocatedGB),2) as 'AllocatedGB',
ROUND(SUM(appdata2.UsedGB),2) as 'UsedGB',
appdata2.date as 'Date'


FROM
(
			SELECT 
			dwh_capacity.application_dimension.id as appid,
			dwh_capacity.application_dimension.name as application,
			ROUND(SUM(dwh_capacity.vm_capacity_fact.provisionedMB/1024),2) as AllocatedGB,
			ROUND(SUM(dwh_capacity.vm_capacity_fact.actualMB/1024),2) as UsedGB,
			dwh_capacity.date_dimension.fulldate as date
			
			FROM dwh_capacity.vm_capacity_Fact
			JOIN dwh_capacity.application_dimension
			ON   dwh_capacity.application_dimension.tk=dwh_capacity.vm_capacity_Fact.applicationtk
			AND  dwh_capacity.application_dimension.name&lt;&gt;'N/A'
			JOIN dwh_capacity.date_dimension
			ON   dwh_capacity.date_dimension.tk=dwh_capacity.vm_capacity_Fact.datetk
						
			WHERE dwh_capacity.date_dimension.fullDate &gt;= (SELECT MAX(dwh_capacity.date_dimension.fullDate) 
                        FROM dwh_capacity.date_dimension JOIN dwh_capacity.vm_capacity_fact 
                        ON dwh_capacity.vm_capacity_fact.dateTk = dwh_capacity.date_dimension.tk) - INTERVAL 0 DAY
                        
                        GROUP BY dwh_capacity.application_dimension.id, dwh_capacity.date_dimension.fulldate 
						
			UNION
			SELECT 	dwh_capacity.application_dimension.id appid,
				dwh_capacity.application_dimension.name application,
				ROUND(SUM(dwh_capacity.chargeback_fact.provisionedCapacityMB)/1024,2) as AllocatedGB,
				ROUND(SUM(dwh_capacity.chargeback_fact.usedCapacityMB)/1024,2) as UsedGB,
				dwh_capacity.date_dimension.fulldate as date
				
			FROM 	dwh_capacity.chargeback_fact
			JOIN 	dwh_capacity.application_dimension
			ON 	dwh_capacity.chargeback_fact.applicationTk = dwh_capacity.application_dimension.tk
			AND  dwh_capacity.application_dimension.name&lt;&gt;'N/A'
			AND 	dwh_capacity.chargeback_fact.mappedByVM = 0
			JOIN 	dwh_capacity.date_dimension
			ON 	dwh_capacity.chargeback_fact.dateTk = dwh_capacity.date_dimension.tk
			
			
			WHERE dwh_capacity.date_dimension.fullDate &gt;= (SELECT MAX(dwh_capacity.date_dimension.fullDate) 
                        FROM dwh_capacity.date_dimension JOIN dwh_capacity.chargeback_fact 
                        ON dwh_capacity.chargeback_fact.dateTk = dwh_capacity.date_dimension.tk) - INTERVAL 0 DAY
			
			
			GROUP BY dwh_capacity.application_dimension.id, dwh_capacity.date_dimension.fulldate
	) appdata2
	
	GROUP BY appdata2.appid, appdata2.date

) apphistory



JOIN

(
SELECT
cagr.application as 'application',
cagr.appid as 'appid',
cagr.CAGR as 'GrowthRate'

FROM
(
SELECT
IFNULL(end.application,begin.application) as 'application',
IFNULL(end.appid,begin.appid) as 'appid',
begin.BeginUsed,
begin.date as 'BeginDate',
end.EndUsed,
end.date as 'EndDate',

TIMESTAMPDIFF(MONTH,begin.date,end.date) as 'DataPoints',

power(end.EndUsed / begin.BeginUsed, 1/TIMESTAMPDIFF(MONTH,begin.date,end.date))-1 as 'CAGR'

FROM
(


SELECT
appdata2.application as 'application',
appdata2.appid as 'appid',
appdata2.UsedGB as 'EndUsed',
appdata2.date as 'Date'


FROM
(
			SELECT 
			dwh_capacity.application_dimension.id as appid,
			dwh_capacity.application_dimension.name as application,
			ROUND(SUM(dwh_capacity.vm_capacity_fact.provisionedMB/1024),2) as AllocatedGB,
			ROUND(SUM(dwh_capacity.vm_capacity_fact.actualMB/1024),2) as UsedGB,
			DATE_FORMAT(dwh_capacity.date_dimension.fulldate, '%Y-%m-%d') as date
			
			FROM dwh_capacity.vm_capacity_Fact
			JOIN dwh_capacity.application_dimension
			ON   dwh_capacity.application_dimension.tk=dwh_capacity.vm_capacity_Fact.applicationtk
			AND  dwh_capacity.application_dimension.name&lt;&gt;'N/A'
			JOIN dwh_capacity.date_dimension
			ON   dwh_capacity.date_dimension.tk=dwh_capacity.vm_capacity_Fact.datetk
						
			WHERE dwh_capacity.date_dimension.fullDate &gt;= (SELECT MAX(dwh_capacity.date_dimension.fullDate) 
                        FROM dwh_capacity.date_dimension JOIN dwh_capacity.vm_capacity_fact 
                        ON dwh_capacity.vm_capacity_fact.dateTk = dwh_capacity.date_dimension.tk) - INTERVAL 0 DAY
                        
                        GROUP BY dwh_capacity.application_dimension.id, dwh_capacity.date_dimension.fulldate 
						
			UNION
			SELECT 	dwh_capacity.application_dimension.id appid,
				dwh_capacity.application_dimension.name application,
				ROUND(SUM(dwh_capacity.chargeback_fact.provisionedCapacityMB)/1024,2) as AllocatedGB,
				ROUND(SUM(dwh_capacity.chargeback_fact.usedCapacityMB)/1024,2) as UsedGB,
				DATE_FORMAT(dwh_capacity.date_dimension.fulldate, '%Y-%m-%d') as date
				
			FROM 	dwh_capacity.chargeback_fact
			JOIN 	dwh_capacity.application_dimension
			ON 	dwh_capacity.chargeback_fact.applicationTk = dwh_capacity.application_dimension.tk
			AND  dwh_capacity.application_dimension.name&lt;&gt;'N/A'
			AND 	dwh_capacity.chargeback_fact.mappedByVM = 0
			JOIN 	dwh_capacity.date_dimension
			ON 	dwh_capacity.chargeback_fact.dateTk = dwh_capacity.date_dimension.tk
			
			
			WHERE dwh_capacity.date_dimension.fullDate &gt;= (SELECT MAX(dwh_capacity.date_dimension.fullDate) 
                        FROM dwh_capacity.date_dimension JOIN dwh_capacity.chargeback_fact 
                        ON dwh_capacity.chargeback_fact.dateTk = dwh_capacity.date_dimension.tk) - INTERVAL 0 DAY
			
			
			GROUP BY dwh_capacity.application_dimension.id, dwh_capacity.date_dimension.fulldate
	) appdata2
	
	GROUP BY appdata2.appid

) end

LEFT JOIN

(

SELECT
begincap.application,
begincap.appid,
begincap.BeginUsed,
begincap.Date

FROM(

SELECT
appdata2.application as 'application',
appdata2.appid as 'appid',
appdata2.UsedGB as 'BeginUsed',
appdata2.date as 'Date'


FROM
(
			SELECT 
			dwh_capacity.application_dimension.id as appid,
			dwh_capacity.application_dimension.name as application,
			ROUND(SUM(dwh_capacity.vm_capacity_fact.provisionedMB/1024),2) as AllocatedGB,
			ROUND(SUM(dwh_capacity.vm_capacity_fact.actualMB/1024),2) as UsedGB,
			DATE_FORMAT(dwh_capacity.date_dimension.fulldate, '%Y-%m-%d') as date
			
			FROM dwh_capacity.vm_capacity_Fact
			JOIN dwh_capacity.application_dimension
			ON   dwh_capacity.application_dimension.tk=dwh_capacity.vm_capacity_Fact.applicationtk
			AND  dwh_capacity.application_dimension.name&lt;&gt;'N/A'
			JOIN dwh_capacity.date_dimension
			ON   dwh_capacity.date_dimension.tk=dwh_capacity.vm_capacity_Fact.datetk
			
			WHERE dwh_capacity.date_dimension.fullDate BETWEEN (SELECT MAX(dwh_capacity.date_dimension.fullDate) 
                        FROM dwh_capacity.date_dimension JOIN dwh_capacity.vm_capacity_fact 
                        ON dwh_capacity.vm_capacity_fact.dateTk = dwh_capacity.date_dimension.tk) - INTERVAL 12 MONTH
				AND
				(SELECT MAX(dwh_capacity.date_dimension.fullDate) 
                        FROM dwh_capacity.date_dimension JOIN dwh_capacity.vm_capacity_fact 
                        ON dwh_capacity.vm_capacity_fact.dateTk = dwh_capacity.date_dimension.tk) - INTERVAL 12 MONTH
                        
                        
                        GROUP BY dwh_capacity.application_dimension.id, dwh_capacity.date_dimension.fulldate 
						
			UNION
			SELECT 	dwh_capacity.application_dimension.id appid,
				dwh_capacity.application_dimension.name application,
				ROUND(SUM(dwh_capacity.chargeback_fact.provisionedCapacityMB)/1024,2) as AllocatedGB,
				ROUND(SUM(dwh_capacity.chargeback_fact.usedCapacityMB)/1024,2) as UsedGB,
				DATE_FORMAT(dwh_capacity.date_dimension.fulldate, '%Y-%m-%d') as date
				
			FROM 	dwh_capacity.chargeback_fact
			JOIN 	dwh_capacity.application_dimension
			ON 	dwh_capacity.chargeback_fact.applicationTk = dwh_capacity.application_dimension.tk
			AND  dwh_capacity.application_dimension.name&lt;&gt;'N/A'
			AND 	dwh_capacity.chargeback_fact.mappedByVM = 0
			JOIN 	dwh_capacity.date_dimension
			ON 	dwh_capacity.chargeback_fact.dateTk = dwh_capacity.date_dimension.tk
			
			
			WHERE dwh_capacity.date_dimension.fullDate BETWEEN (SELECT MAX(dwh_capacity.date_dimension.fullDate) 
                        FROM dwh_capacity.date_dimension JOIN dwh_capacity.chargeback_fact 
                        ON dwh_capacity.chargeback_fact.dateTk = dwh_capacity.date_dimension.tk) - INTERVAL 12 MONTH
				AND
			(SELECT MAX(dwh_capacity.date_dimension.fullDate) 
                        FROM dwh_capacity.date_dimension JOIN dwh_capacity.chargeback_fact 
                        ON dwh_capacity.chargeback_fact.dateTk = dwh_capacity.date_dimension.tk) - INTERVAL 12 MONTH
						
			GROUP BY dwh_capacity.application_dimension.id, dwh_capacity.date_dimension.fulldate
	) appdata2
	
	GROUP BY appdata2.appid
) begincap
HAVING begincap.BeginUsed &gt; 0 

) begin ON begin.appid=end.appid

HAVING begin.BeginUsed is not null AND DataPoints &gt; 0


) cagr

 ) cag ON cag.appid=apphistory.happid 



/* Get 5th Month Future Data */

UNION

SELECT 
cag.application as 'Application',
cag.appid as 'appid',
null as 'AllocatedGB',
null as 'UsedGB',
DATE_ADD(apphistory.date, INTERVAL 5 MONTH) as 'Date',
cag.growthrate as 'GrowthRate',
apphistory.AllocatedGB as 'ProjectedAllocatedGB',
(apphistory.usedGB*(cag.growthrate*5))+apphistory.usedGB as 'ProjectedUsedGB'


FROM

(
SELECT
appdata2.appid as 'happid',
ROUND(SUM(appdata2.AllocatedGB),2) as 'AllocatedGB',
ROUND(SUM(appdata2.UsedGB),2) as 'UsedGB',
appdata2.date as 'Date'


FROM
(
			SELECT 
			dwh_capacity.application_dimension.id as appid,
			dwh_capacity.application_dimension.name as application,
			ROUND(SUM(dwh_capacity.vm_capacity_fact.provisionedMB/1024),2) as AllocatedGB,
			ROUND(SUM(dwh_capacity.vm_capacity_fact.actualMB/1024),2) as UsedGB,
			dwh_capacity.date_dimension.fulldate as date
			
			FROM dwh_capacity.vm_capacity_Fact
			JOIN dwh_capacity.application_dimension
			ON   dwh_capacity.application_dimension.tk=dwh_capacity.vm_capacity_Fact.applicationtk
			AND  dwh_capacity.application_dimension.name&lt;&gt;'N/A'
			JOIN dwh_capacity.date_dimension
			ON   dwh_capacity.date_dimension.tk=dwh_capacity.vm_capacity_Fact.datetk
						
			WHERE dwh_capacity.date_dimension.fullDate &gt;= (SELECT MAX(dwh_capacity.date_dimension.fullDate) 
                        FROM dwh_capacity.date_dimension JOIN dwh_capacity.vm_capacity_fact 
                        ON dwh_capacity.vm_capacity_fact.dateTk = dwh_capacity.date_dimension.tk) - INTERVAL 0 DAY
                        
                        GROUP BY dwh_capacity.application_dimension.id, dwh_capacity.date_dimension.fulldate 
						
			UNION
			SELECT 	dwh_capacity.application_dimension.id appid,
				dwh_capacity.application_dimension.name application,
				ROUND(SUM(dwh_capacity.chargeback_fact.provisionedCapacityMB)/1024,2) as AllocatedGB,
				ROUND(SUM(dwh_capacity.chargeback_fact.usedCapacityMB)/1024,2) as UsedGB,
				dwh_capacity.date_dimension.fulldate as date
				
			FROM 	dwh_capacity.chargeback_fact
			JOIN 	dwh_capacity.application_dimension
			ON 	dwh_capacity.chargeback_fact.applicationTk = dwh_capacity.application_dimension.tk
			AND  dwh_capacity.application_dimension.name&lt;&gt;'N/A'
			AND 	dwh_capacity.chargeback_fact.mappedByVM = 0
			JOIN 	dwh_capacity.date_dimension
			ON 	dwh_capacity.chargeback_fact.dateTk = dwh_capacity.date_dimension.tk
			
			
			WHERE dwh_capacity.date_dimension.fullDate &gt;= (SELECT MAX(dwh_capacity.date_dimension.fullDate) 
                        FROM dwh_capacity.date_dimension JOIN dwh_capacity.chargeback_fact 
                        ON dwh_capacity.chargeback_fact.dateTk = dwh_capacity.date_dimension.tk) - INTERVAL 0 DAY
			
			
			GROUP BY dwh_capacity.application_dimension.id, dwh_capacity.date_dimension.fulldate
	) appdata2
	
	GROUP BY appdata2.appid, appdata2.date

) apphistory



JOIN

(
SELECT
cagr.application as 'application',
cagr.appid as 'appid',
cagr.CAGR as 'GrowthRate'

FROM
(
SELECT
IFNULL(end.application,begin.application) as 'application',
IFNULL(end.appid,begin.appid) as 'appid',
begin.BeginUsed,
begin.date as 'BeginDate',
end.EndUsed,
end.date as 'EndDate',

TIMESTAMPDIFF(MONTH,begin.date,end.date) as 'DataPoints',

power(end.EndUsed / begin.BeginUsed, 1/TIMESTAMPDIFF(MONTH,begin.date,end.date))-1 as 'CAGR'

FROM
(


SELECT
appdata2.application as 'application',
appdata2.appid as 'appid',
appdata2.UsedGB as 'EndUsed',
appdata2.date as 'Date'


FROM
(
			SELECT 
			dwh_capacity.application_dimension.id as appid,
			dwh_capacity.application_dimension.name as application,
			ROUND(SUM(dwh_capacity.vm_capacity_fact.provisionedMB/1024),2) as AllocatedGB,
			ROUND(SUM(dwh_capacity.vm_capacity_fact.actualMB/1024),2) as UsedGB,
			DATE_FORMAT(dwh_capacity.date_dimension.fulldate, '%Y-%m-%d') as date
			
			FROM dwh_capacity.vm_capacity_Fact
			JOIN dwh_capacity.application_dimension
			ON   dwh_capacity.application_dimension.tk=dwh_capacity.vm_capacity_Fact.applicationtk
			AND  dwh_capacity.application_dimension.name&lt;&gt;'N/A'
			JOIN dwh_capacity.date_dimension
			ON   dwh_capacity.date_dimension.tk=dwh_capacity.vm_capacity_Fact.datetk
						
			WHERE dwh_capacity.date_dimension.fullDate &gt;= (SELECT MAX(dwh_capacity.date_dimension.fullDate) 
                        FROM dwh_capacity.date_dimension JOIN dwh_capacity.vm_capacity_fact 
                        ON dwh_capacity.vm_capacity_fact.dateTk = dwh_capacity.date_dimension.tk) - INTERVAL 0 DAY
                        
                        GROUP BY dwh_capacity.application_dimension.id, dwh_capacity.date_dimension.fulldate 
						
			UNION
			SELECT 	dwh_capacity.application_dimension.id appid,
				dwh_capacity.application_dimension.name application,
				ROUND(SUM(dwh_capacity.chargeback_fact.provisionedCapacityMB)/1024,2) as AllocatedGB,
				ROUND(SUM(dwh_capacity.chargeback_fact.usedCapacityMB)/1024,2) as UsedGB,
				DATE_FORMAT(dwh_capacity.date_dimension.fulldate, '%Y-%m-%d') as date
				
			FROM 	dwh_capacity.chargeback_fact
			JOIN 	dwh_capacity.application_dimension
			ON 	dwh_capacity.chargeback_fact.applicationTk = dwh_capacity.application_dimension.tk
			AND  dwh_capacity.application_dimension.name&lt;&gt;'N/A'
			AND 	dwh_capacity.chargeback_fact.mappedByVM = 0
			JOIN 	dwh_capacity.date_dimension
			ON 	dwh_capacity.chargeback_fact.dateTk = dwh_capacity.date_dimension.tk
			
			
			WHERE dwh_capacity.date_dimension.fullDate &gt;= (SELECT MAX(dwh_capacity.date_dimension.fullDate) 
                        FROM dwh_capacity.date_dimension JOIN dwh_capacity.chargeback_fact 
                        ON dwh_capacity.chargeback_fact.dateTk = dwh_capacity.date_dimension.tk) - INTERVAL 0 DAY
			
			
			GROUP BY dwh_capacity.application_dimension.id, dwh_capacity.date_dimension.fulldate
	) appdata2
	
	GROUP BY appdata2.appid

) end

LEFT JOIN

(

SELECT
begincap.application,
begincap.appid,
begincap.BeginUsed,
begincap.Date

FROM(

SELECT
appdata2.application as 'application',
appdata2.appid as 'appid',
appdata2.UsedGB as 'BeginUsed',
appdata2.date as 'Date'


FROM
(
			SELECT 
			dwh_capacity.application_dimension.id as appid,
			dwh_capacity.application_dimension.name as application,
			ROUND(SUM(dwh_capacity.vm_capacity_fact.provisionedMB/1024),2) as AllocatedGB,
			ROUND(SUM(dwh_capacity.vm_capacity_fact.actualMB/1024),2) as UsedGB,
			DATE_FORMAT(dwh_capacity.date_dimension.fulldate, '%Y-%m-%d') as date
			
			FROM dwh_capacity.vm_capacity_Fact
			JOIN dwh_capacity.application_dimension
			ON   dwh_capacity.application_dimension.tk=dwh_capacity.vm_capacity_Fact.applicationtk
			AND  dwh_capacity.application_dimension.name&lt;&gt;'N/A'
			JOIN dwh_capacity.date_dimension
			ON   dwh_capacity.date_dimension.tk=dwh_capacity.vm_capacity_Fact.datetk
			
			WHERE dwh_capacity.date_dimension.fullDate BETWEEN (SELECT MAX(dwh_capacity.date_dimension.fullDate) 
                        FROM dwh_capacity.date_dimension JOIN dwh_capacity.vm_capacity_fact 
                        ON dwh_capacity.vm_capacity_fact.dateTk = dwh_capacity.date_dimension.tk) - INTERVAL 12 MONTH
				AND
				(SELECT MAX(dwh_capacity.date_dimension.fullDate) 
                        FROM dwh_capacity.date_dimension JOIN dwh_capacity.vm_capacity_fact 
                        ON dwh_capacity.vm_capacity_fact.dateTk = dwh_capacity.date_dimension.tk) - INTERVAL 12 MONTH
                        
                        
                        GROUP BY dwh_capacity.application_dimension.id, dwh_capacity.date_dimension.fulldate 
						
			UNION
			SELECT 	dwh_capacity.application_dimension.id appid,
				dwh_capacity.application_dimension.name application,
				ROUND(SUM(dwh_capacity.chargeback_fact.provisionedCapacityMB)/1024,2) as AllocatedGB,
				ROUND(SUM(dwh_capacity.chargeback_fact.usedCapacityMB)/1024,2) as UsedGB,
				DATE_FORMAT(dwh_capacity.date_dimension.fulldate, '%Y-%m-%d') as date
				
			FROM 	dwh_capacity.chargeback_fact
			JOIN 	dwh_capacity.application_dimension
			ON 	dwh_capacity.chargeback_fact.applicationTk = dwh_capacity.application_dimension.tk
			AND  dwh_capacity.application_dimension.name&lt;&gt;'N/A'
			AND 	dwh_capacity.chargeback_fact.mappedByVM = 0
			JOIN 	dwh_capacity.date_dimension
			ON 	dwh_capacity.chargeback_fact.dateTk = dwh_capacity.date_dimension.tk
			
			
			WHERE dwh_capacity.date_dimension.fullDate BETWEEN (SELECT MAX(dwh_capacity.date_dimension.fullDate) 
                        FROM dwh_capacity.date_dimension JOIN dwh_capacity.chargeback_fact 
                        ON dwh_capacity.chargeback_fact.dateTk = dwh_capacity.date_dimension.tk) - INTERVAL 12 MONTH
				AND
				(SELECT MAX(dwh_capacity.date_dimension.fullDate) 
                        FROM dwh_capacity.date_dimension JOIN dwh_capacity.chargeback_fact 
                        ON dwh_capacity.chargeback_fact.dateTk = dwh_capacity.date_dimension.tk) - INTERVAL 12 MONTH
						
			GROUP BY dwh_capacity.application_dimension.id, dwh_capacity.date_dimension.fulldate
	) appdata2
	
	GROUP BY appdata2.appid
) begincap
HAVING begincap.BeginUsed &gt; 0 

) begin ON begin.appid=end.appid

HAVING begin.BeginUsed is not null AND DataPoints &gt; 0


) cagr

 ) cag ON cag.appid=apphistory.happid 




/* Get 6th Month Future Data */

UNION

SELECT 
cag.application as 'Application',
cag.appid as 'appid',
null as 'AllocatedGB',
null as 'UsedGB',
DATE_ADD(apphistory.date, INTERVAL 6 MONTH) as 'Date',
cag.growthrate as 'GrowthRate',
apphistory.AllocatedGB as 'ProjectedAllocatedGB',
(apphistory.usedGB*(cag.growthrate*6))+apphistory.usedGB as 'ProjectedUsedGB'


FROM

(
SELECT
appdata2.appid as 'happid',
ROUND(SUM(appdata2.AllocatedGB),2) as 'AllocatedGB',
ROUND(SUM(appdata2.UsedGB),2) as 'UsedGB',
appdata2.date as 'Date'


FROM
(
			SELECT 
			dwh_capacity.application_dimension.id as appid,
			dwh_capacity.application_dimension.name as application,
			ROUND(SUM(dwh_capacity.vm_capacity_fact.provisionedMB/1024),2) as AllocatedGB,
			ROUND(SUM(dwh_capacity.vm_capacity_fact.actualMB/1024),2) as UsedGB,
			dwh_capacity.date_dimension.fulldate as date
			
			FROM dwh_capacity.vm_capacity_Fact
			JOIN dwh_capacity.application_dimension
			ON   dwh_capacity.application_dimension.tk=dwh_capacity.vm_capacity_Fact.applicationtk
			AND  dwh_capacity.application_dimension.name&lt;&gt;'N/A'
			JOIN dwh_capacity.date_dimension
			ON   dwh_capacity.date_dimension.tk=dwh_capacity.vm_capacity_Fact.datetk
						
			WHERE dwh_capacity.date_dimension.fullDate &gt;= (SELECT MAX(dwh_capacity.date_dimension.fullDate) 
                        FROM dwh_capacity.date_dimension JOIN dwh_capacity.vm_capacity_fact 
                        ON dwh_capacity.vm_capacity_fact.dateTk = dwh_capacity.date_dimension.tk) - INTERVAL 0 DAY
                        
                        GROUP BY dwh_capacity.application_dimension.id, dwh_capacity.date_dimension.fulldate 
						
			UNION
			SELECT 	dwh_capacity.application_dimension.id appid,
				dwh_capacity.application_dimension.name application,
				ROUND(SUM(dwh_capacity.chargeback_fact.provisionedCapacityMB)/1024,2) as AllocatedGB,
				ROUND(SUM(dwh_capacity.chargeback_fact.usedCapacityMB)/1024,2) as UsedGB,
				dwh_capacity.date_dimension.fulldate as date
				
			FROM 	dwh_capacity.chargeback_fact
			JOIN 	dwh_capacity.application_dimension
			ON 	dwh_capacity.chargeback_fact.applicationTk = dwh_capacity.application_dimension.tk
			AND  dwh_capacity.application_dimension.name&lt;&gt;'N/A'
			AND 	dwh_capacity.chargeback_fact.mappedByVM = 0
			JOIN 	dwh_capacity.date_dimension
			ON 	dwh_capacity.chargeback_fact.dateTk = dwh_capacity.date_dimension.tk
			
			
			WHERE dwh_capacity.date_dimension.fullDate &gt;= (SELECT MAX(dwh_capacity.date_dimension.fullDate) 
                        FROM dwh_capacity.date_dimension JOIN dwh_capacity.chargeback_fact 
                        ON dwh_capacity.chargeback_fact.dateTk = dwh_capacity.date_dimension.tk) - INTERVAL 0 DAY
			
			
			GROUP BY dwh_capacity.application_dimension.id, dwh_capacity.date_dimension.fulldate
	) appdata2
	
	GROUP BY appdata2.appid, appdata2.date

) apphistory



JOIN

(
SELECT
cagr.application as 'application',
cagr.appid as 'appid',
cagr.CAGR as 'GrowthRate'

FROM
(
SELECT
IFNULL(end.application,begin.application) as 'application',
IFNULL(end.appid,begin.appid) as 'appid',
begin.BeginUsed,
begin.date as 'BeginDate',
end.EndUsed,
end.date as 'EndDate',

TIMESTAMPDIFF(MONTH,begin.date,end.date) as 'DataPoints',

power(end.EndUsed / begin.BeginUsed, 1/TIMESTAMPDIFF(MONTH,begin.date,end.date))-1 as 'CAGR'

FROM
(


SELECT
appdata2.application as 'application',
appdata2.appid as 'appid',
appdata2.UsedGB as 'EndUsed',
appdata2.date as 'Date'


FROM
(
			SELECT 
			dwh_capacity.application_dimension.id as appid,
			dwh_capacity.application_dimension.name as application,
			ROUND(SUM(dwh_capacity.vm_capacity_fact.provisionedMB/1024),2) as AllocatedGB,
			ROUND(SUM(dwh_capacity.vm_capacity_fact.actualMB/1024),2) as UsedGB,
			DATE_FORMAT(dwh_capacity.date_dimension.fulldate, '%Y-%m-%d') as date
			
			FROM dwh_capacity.vm_capacity_Fact
			JOIN dwh_capacity.application_dimension
			ON   dwh_capacity.application_dimension.tk=dwh_capacity.vm_capacity_Fact.applicationtk
			AND  dwh_capacity.application_dimension.name&lt;&gt;'N/A'
			JOIN dwh_capacity.date_dimension
			ON   dwh_capacity.date_dimension.tk=dwh_capacity.vm_capacity_Fact.datetk
						
			WHERE dwh_capacity.date_dimension.fullDate &gt;= (SELECT MAX(dwh_capacity.date_dimension.fullDate) 
                        FROM dwh_capacity.date_dimension JOIN dwh_capacity.vm_capacity_fact 
                        ON dwh_capacity.vm_capacity_fact.dateTk = dwh_capacity.date_dimension.tk) - INTERVAL 0 DAY
                        
                        GROUP BY dwh_capacity.application_dimension.id, dwh_capacity.date_dimension.fulldate 
						
			UNION
			SELECT 	dwh_capacity.application_dimension.id appid,
				dwh_capacity.application_dimension.name application,
				ROUND(SUM(dwh_capacity.chargeback_fact.provisionedCapacityMB)/1024,2) as AllocatedGB,
				ROUND(SUM(dwh_capacity.chargeback_fact.usedCapacityMB)/1024,2) as UsedGB,
				DATE_FORMAT(dwh_capacity.date_dimension.fulldate, '%Y-%m-%d') as date
				
			FROM 	dwh_capacity.chargeback_fact
			JOIN 	dwh_capacity.application_dimension
			ON 	dwh_capacity.chargeback_fact.applicationTk = dwh_capacity.application_dimension.tk
			AND  dwh_capacity.application_dimension.name&lt;&gt;'N/A'
			AND 	dwh_capacity.chargeback_fact.mappedByVM = 0
			JOIN 	dwh_capacity.date_dimension
			ON 	dwh_capacity.chargeback_fact.dateTk = dwh_capacity.date_dimension.tk
			
			
			WHERE dwh_capacity.date_dimension.fullDate &gt;= (SELECT MAX(dwh_capacity.date_dimension.fullDate) 
                        FROM dwh_capacity.date_dimension JOIN dwh_capacity.chargeback_fact 
                        ON dwh_capacity.chargeback_fact.dateTk = dwh_capacity.date_dimension.tk) - INTERVAL 0 DAY
			
			
			GROUP BY dwh_capacity.application_dimension.id, dwh_capacity.date_dimension.fulldate
	) appdata2
	
	GROUP BY appdata2.appid

) end

LEFT JOIN

(

SELECT
begincap.application,
begincap.appid,
begincap.BeginUsed,
begincap.Date

FROM(

SELECT
appdata2.application as 'application',
appdata2.appid as 'appid',
appdata2.UsedGB as 'BeginUsed',
appdata2.date as 'Date'


FROM
(
			SELECT 
			dwh_capacity.application_dimension.id as appid,
			dwh_capacity.application_dimension.name as application,
			ROUND(SUM(dwh_capacity.vm_capacity_fact.provisionedMB/1024),2) as AllocatedGB,
			ROUND(SUM(dwh_capacity.vm_capacity_fact.actualMB/1024),2) as UsedGB,
			DATE_FORMAT(dwh_capacity.date_dimension.fulldate, '%Y-%m-%d') as date
			
			FROM dwh_capacity.vm_capacity_Fact
			JOIN dwh_capacity.application_dimension
			ON   dwh_capacity.application_dimension.tk=dwh_capacity.vm_capacity_Fact.applicationtk
			AND  dwh_capacity.application_dimension.name&lt;&gt;'N/A'
			JOIN dwh_capacity.date_dimension
			ON   dwh_capacity.date_dimension.tk=dwh_capacity.vm_capacity_Fact.datetk
			
			WHERE dwh_capacity.date_dimension.fullDate BETWEEN (SELECT MAX(dwh_capacity.date_dimension.fullDate) 
                        FROM dwh_capacity.date_dimension JOIN dwh_capacity.vm_capacity_fact 
                        ON dwh_capacity.vm_capacity_fact.dateTk = dwh_capacity.date_dimension.tk) - INTERVAL 12 MONTH
				AND
				(SELECT MAX(dwh_capacity.date_dimension.fullDate) 
                        FROM dwh_capacity.date_dimension JOIN dwh_capacity.vm_capacity_fact 
                        ON dwh_capacity.vm_capacity_fact.dateTk = dwh_capacity.date_dimension.tk) - INTERVAL 12 MONTH
                        
                        
                        GROUP BY dwh_capacity.application_dimension.id, dwh_capacity.date_dimension.fulldate 
						
			UNION
			SELECT 	dwh_capacity.application_dimension.id appid,
				dwh_capacity.application_dimension.name application,
				ROUND(SUM(dwh_capacity.chargeback_fact.provisionedCapacityMB)/1024,2) as AllocatedGB,
				ROUND(SUM(dwh_capacity.chargeback_fact.usedCapacityMB)/1024,2) as UsedGB,
				DATE_FORMAT(dwh_capacity.date_dimension.fulldate, '%Y-%m-%d') as date
				
			FROM 	dwh_capacity.chargeback_fact
			JOIN 	dwh_capacity.application_dimension
			ON 	dwh_capacity.chargeback_fact.applicationTk = dwh_capacity.application_dimension.tk
			AND  dwh_capacity.application_dimension.name&lt;&gt;'N/A'
			AND 	dwh_capacity.chargeback_fact.mappedByVM = 0
			JOIN 	dwh_capacity.date_dimension
			ON 	dwh_capacity.chargeback_fact.dateTk = dwh_capacity.date_dimension.tk
			
			
			WHERE dwh_capacity.date_dimension.fullDate BETWEEN (SELECT MAX(dwh_capacity.date_dimension.fullDate) 
                        FROM dwh_capacity.date_dimension JOIN dwh_capacity.chargeback_fact 
                        ON dwh_capacity.chargeback_fact.dateTk = dwh_capacity.date_dimension.tk) - INTERVAL 12 MONTH
				AND
				(SELECT MAX(dwh_capacity.date_dimension.fullDate) 
                        FROM dwh_capacity.date_dimension JOIN dwh_capacity.chargeback_fact 
                        ON dwh_capacity.chargeback_fact.dateTk = dwh_capacity.date_dimension.tk) - INTERVAL 12 MONTH
						
			GROUP BY dwh_capacity.application_dimension.id, dwh_capacity.date_dimension.fulldate
	) appdata2
	
	GROUP BY appdata2.appid
) begincap
HAVING begincap.BeginUsed &gt; 0 

) begin ON begin.appid=end.appid

HAVING begin.BeginUsed is not null AND DataPoints &gt; 0


) cagr

 ) cag ON cag.appid=apphistory.happid 

</sqlText>
		<mdProjectedItems><mdProjectedItem name="Application"/><mdProjectedItem name="appid"/><mdProjectedItem name="AllocatedGB"/><mdProjectedItem name="UsedGB"/><mdProjectedItem name="Date"/><mdProjectedItem name="GrowthRate"/><mdProjectedItem name="ProjectedAllocatedGB"/><mdProjectedItem name="ProjectedUsedGB"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Application"><expression>[SQL2].[Application]</expression></dataItem><dataItem name="appid"><expression>[SQL2].[appid]</expression></dataItem><dataItem name="AllocatedGB"><expression>[SQL2].[AllocatedGB]</expression></dataItem><dataItem name="UsedGB" aggregate="total"><expression>[SQL2].[UsedGB]</expression></dataItem><dataItem name="Date"><expression>[SQL2].[Date]</expression></dataItem><dataItem name="GrowthRate"><expression>[SQL2].[GrowthRate]</expression></dataItem><dataItem name="ProjectedAllocatedGB"><expression>[SQL2].[ProjectedAllocatedGB]</expression></dataItem><dataItem name="ProjectedUsedGB" aggregate="total"><expression>[SQL2].[ProjectedUsedGB]</expression></dataItem></selection>
		<detailFilters><detailFilter use="optional"><filterExpression>[Application] in ?sApp?</filterExpression></detailFilter></detailFilters></query><query name="Chargeback + Performance Metrics">
			<source>
				
			<sqlQuery dataSource="dwh_capacity" name="SQL5" type="passThrough">
			<sqlText>SELECT 	total.app AS 'Application',
	(total.allocatedGB) AS 'Allocated (GB)',
	(total.usedGB) AS 'Used (GB)',
	SUM(total.totalIops) AS 'Total Average IOPS',
	SUM(total.maxTotalIops) AS 'Peak Total IOPS',
	SUM(total.totalMbps) AS 'Total Average MB/s',
	SUM(total.maxTotalIops) AS 'Peak Total MB/s',
	CEIL(AVG(total.avgMs)) AS 'Average Latency',
	CEIL(MAX(total.maxMs)) AS 'Peak Latency'
FROM 	(
	SELECT 	chargeback.application AS app,
		chargeback.provGB AS allocatedGB,
		chargeback.usedGB AS usedGB,
		performance.totalIops AS totalIops,
		performance.maxTotalIops AS maxTotalIops,
		performance.totalMbps AS totalMbps,
		performance.maxTotalMbps AS maxTotalMbps,
		performance.avgMs AS avgMs,
		performance.maxMs AS maxMs
	FROM 	(
		SELECT 	vmChargeback.appTk,
			vmChargeback.application,
			SUM(vmChargeback.provGB) provGB,
			SUM(vmChargeback.usedGB) usedGB
		FROM 	(		
			SELECT 	IFNULL(dwh_inventory.application.id, 'N/A') appTk,
				IFNULL(dwh_inventory.application.name, 'N/A') application,
				ROUND(SUM(dwh_inventory.hv_virtual_disk.capacityMB)/1024, 2) provGB,
				ROUND(SUM(dwh_inventory.hv_virtual_disk.usedCapacityMB)/1024, 2) usedGB
			FROM 	dwh_inventory.hv_virtual_disk
			JOIN 	dwh_inventory.hv_virtual_machine_to_disk
			ON 	dwh_inventory.hv_virtual_disk.id = dwh_inventory.hv_virtual_machine_to_disk.virtualDiskId
			JOIN 	dwh_inventory.hv_virtual_machine
			ON 	dwh_inventory.hv_virtual_machine_to_disk.virtualMachineId = dwh_inventory.hv_virtual_machine.id
			LEFT JOIN 	dwh_inventory.vm_to_application
			ON 	dwh_inventory.hv_virtual_machine.id = dwh_inventory.vm_to_application.vmId
			LEFT JOIN 	dwh_inventory.application
			ON 	dwh_inventory.vm_to_application.applicationId = dwh_inventory.application.id
			GROUP BY
				dwh_inventory.application.id
			UNION
			SELECT 	dwh_capacity.application_dimension.id appTk,
				dwh_capacity.application_dimension.name application,
				ROUND(SUM(dwh_capacity.chargeback_fact.provisionedCapacityMB)/1024, 2) provGB,
				ROUND(SUM(dwh_capacity.chargeback_fact.usedCapacityMB)/1024, 2) usedGB
			FROM 	dwh_capacity.chargeback_fact
			JOIN 	dwh_capacity.application_dimension
			ON 	dwh_capacity.chargeback_fact.applicationTk = dwh_capacity.application_dimension.tk
			AND 	dwh_capacity.chargeback_fact.mappedByVM = 0
			JOIN 	dwh_capacity.date_dimension
			ON 	dwh_capacity.chargeback_fact.dateTk = dwh_capacity.date_dimension.tk
			AND 	dwh_capacity.date_dimension.latest = 1
			GROUP BY
				dwh_capacity.application_dimension.id
			) vmChargeback
		GROUP BY
			vmChargeback.appTk
		) chargeback
	LEFT JOIN 	(
		SELECT 	perf.appTk,
			CEIL(AVG(perf.totalIops)) AS totalIops,
			MAX(perf.totalIops) AS maxTotalIops,
			CEIL(AVG(perf.totalMbps)) AS totalMbps,
			MAX(perf.totalMbps) AS maxTotalMbps,
			ROUND(AVG(perf.avgMs), 2) AS avgMs,
			MAX(perf.maxMs) AS maxMs
		FROM 	(
			SELECT 	dwh_inventory.application.id appTk,
				dwh_performance.time_dimension.hourDateTime,
				ROUND(SUM(dwh_performance.vm_hourly_performance_fact.totalIops),0) totalIops,
				ROUND(SUM(dwh_performance.vm_hourly_performance_fact.totalThroughput),0) totalMbps,
				ROUND(AVG(dwh_performance.vm_hourly_performance_fact.totalResponseTime),0) avgMs,
				ROUND(MAX(dwh_performance.vm_hourly_performance_fact.totalResponseTime),0) maxMs
			FROM 	dwh_performance.vm_hourly_performance_fact
			JOIN 	dwh_performance.time_dimension
			ON 	dwh_performance.vm_hourly_performance_fact.timeTk = dwh_performance.time_dimension.tk
			JOIN 	dwh_performance.vm_dimension
			ON 	dwh_performance.vm_hourly_performance_fact.vmTk = dwh_performance.vm_dimension.tk
			AND 	dwh_performance.vm_dimension.latest = 1
			JOIN 	dwh_inventory.vm_to_application
			ON 	dwh_performance.vm_dimension.id = dwh_inventory.vm_to_application.vmId
			JOIN 	dwh_inventory.application
			ON 	dwh_inventory.vm_to_application.applicationId = dwh_inventory.application.id
			GROUP BY
				dwh_inventory.application.id,
				dwh_performance.time_dimension.tk
			UNION
			SELECT 	dwh_performance.application_dimension.id appTk,
				dwh_performance.time_dimension.hourDateTime,
				ROUND(SUM(dwh_performance.volume_hourly_performance_fact.totalIops),0) totalIops,
				ROUND(SUM(dwh_performance.volume_hourly_performance_fact.totalThroughput),0) totalMbps,
				ROUND(AVG(dwh_performance.volume_hourly_performance_fact.totalResponseTime),0) avgMs,
				ROUND(MAX(dwh_performance.volume_hourly_performance_fact.totalResponseTime),0) maxMs
			FROM 	dwh_performance.volume_hourly_performance_fact
			JOIN 	dwh_performance.time_dimension
			ON 	dwh_performance.volume_hourly_performance_fact.timeTk = dwh_performance.time_dimension.tk
			JOIN 	dwh_performance.application_dimension
			ON 	dwh_performance.volume_hourly_performance_fact.applicationTk = dwh_performance.application_dimension.tk
			GROUP BY
				dwh_performance.application_dimension.id,
				dwh_performance.time_dimension.tk
			UNION
			SELECT 	dwh_performance.application_dimension.id appTk,
				dwh_performance.time_dimension.hourDateTime,
				ROUND(SUM(dwh_performance.internal_volume_hourly_performance_fact.totalIops),0) totalIops,
				ROUND(SUM(dwh_performance.internal_volume_hourly_performance_fact.totalThroughput),0) totalMbps,
				ROUND(AVG(dwh_performance.internal_volume_hourly_performance_fact.totalResponseTime),0) avgMs,
				ROUND(MAX(dwh_performance.internal_volume_hourly_performance_fact.totalResponseTime),0) maxMs
			FROM 	dwh_performance.internal_volume_hourly_performance_fact
			JOIN 	dwh_performance.time_dimension
			ON 	dwh_performance.internal_volume_hourly_performance_fact.timeTk = dwh_performance.time_dimension.tk
			JOIN 	dwh_performance.application_dimension
			ON 	dwh_performance.internal_volume_hourly_performance_fact.applicationTk = dwh_performance.application_dimension.tk
			GROUP BY
				dwh_performance.application_dimension.id,
				dwh_performance.time_dimension.tk		
			) perf
		GROUP BY
			perf.appTk
		) performance
	ON 	chargeback.appTk = performance.appTk
	GROUP BY
		chargeback.appTk
	) total
GROUP BY
	total.app</sqlText>
		<mdProjectedItems><mdProjectedItem name="Application"/><mdProjectedItem name="Allocated (GB)"/><mdProjectedItem name="Used (GB)"/><mdProjectedItem name="Total Average IOPS"/><mdProjectedItem name="Peak Total IOPS"/><mdProjectedItem name="Total Average MB/s"/><mdProjectedItem name="Peak Total MB/s"/><mdProjectedItem name="Average Latency"/><mdProjectedItem name="Peak Latency"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Application" rollupAggregate="none"><expression>[SQL5].[Application]</expression></dataItem><dataItem aggregate="average" name="Allocated (GB)"><expression>[SQL5].[Allocated (GB)]</expression></dataItem><dataItem aggregate="average" name="Used (GB)"><expression>[SQL5].[Used (GB)]</expression></dataItem><dataItem aggregate="average" name="Used (%)"><expression>[SQL5].[Used (GB)]/[SQL5].[Allocated (GB)]</expression></dataItem><dataItem aggregate="average" name="Total IOPS"><expression>[SQL5].[Total Average IOPS]</expression></dataItem><dataItem aggregate="average" name="Peak IOPS"><expression>[SQL5].[Peak Total IOPS]</expression></dataItem><dataItem aggregate="average" name="Total MB/s"><expression>[SQL5].[Total Average MB/s]</expression></dataItem><dataItem aggregate="average" name="Peak MB/s"><expression>[SQL5].[Peak Total MB/s]</expression></dataItem><dataItem aggregate="average" name="Avg. Latency"><expression>[SQL5].[Average Latency]</expression></dataItem><dataItem aggregate="average" name="Peak Latency"><expression>[SQL5].[Peak Latency]</expression></dataItem><dataItem aggregate="average" name="Global Used (%)"><expression>Total(Total([SQL5].[Used (GB)]))/Total(Total([SQL5].[Allocated (GB)]))</expression></dataItem><dataItemListSummary aggregateMethod="total" name="Total(Utilization (%))" refDataItem="Used (%)"/><dataItem aggregate="total" name="Allocated (TB)"><expression>[SQL5].[Allocated (GB)]/1024</expression></dataItem><dataItem aggregate="total" name="Used (TB)"><expression>[SQL5].[Used (GB)]/1024</expression></dataItem></selection>
		<detailFilters><detailFilter use="optional"><filterExpression>[Application] in ?sApp?</filterExpression></detailFilter></detailFilters></query><query name="Performance Trending">
			<source>
				
			<sqlQuery dataSource="dwh_performance" name="SQL2" type="passThrough">
			<sqlText>SELECT 	IFNULL(dwh_inventory.application.name, 'N/A') AS 'Application',
	dwh_performance.date_dimension.fullDate AS 'Date',
	SUM(dwh_performance.vm_daily_performance_fact.writeIops) AS 'Write IOPS',
	SUM(dwh_performance.vm_daily_performance_fact.readIops) AS 'Read IOPS',
	SUM(dwh_performance.vm_daily_performance_fact.writeThroughput) AS 'Write Throughput',
	SUM(dwh_performance.vm_daily_performance_fact.readThroughput) AS 'Read Throughput',
	ROUND(AVG(dwh_performance.vm_daily_performance_fact.readResponseTime), 2) AS 'Read Latency',
	ROUND(AVG(dwh_performance.vm_daily_performance_fact.writeResponseTime), 2) AS 'Write Latency',

	ROUND(AVG(dwh_performance.vm_daily_performance_fact.cpuUtilization), 2) AS 'CPU Utilization',
	ROUND(AVG(dwh_performance.vm_daily_performance_fact.memoryUtilization), 2) AS 'Memory Utilization'

FROM 	dwh_performance.vm_daily_performance_fact
JOIN 	dwh_performance.date_dimension
ON 	dwh_performance.vm_daily_performance_fact.dateTk = dwh_performance.date_dimension.tk
AND 	dwh_performance.date_dimension.fullDate &gt;= (SELECT MAX(dwh_performance.date_dimension.fullDate)
							FROM 	dwh_performance.date_dimension
							JOIN 	dwh_performance.vm_daily_performance_fact
							ON 	dwh_performance.vm_daily_performance_fact.dateTk = dwh_performance.date_dimension.tk
							) - INTERVAL 30 DAY
JOIN 	dwh_performance.vm_dimension
ON 	dwh_performance.vm_daily_performance_fact.vmTk = dwh_performance.vm_dimension.tk
AND 	dwh_performance.vm_dimension.latest = 1
LEFT JOIN 	dwh_inventory.vm_to_application
ON 	dwh_performance.vm_dimension.id = dwh_inventory.vm_to_application.vmId
LEFT JOIN 	dwh_inventory.application
ON 	dwh_inventory.vm_to_application.applicationId = dwh_inventory.application.id
GROUP BY
	IFNULL(dwh_inventory.application.id, 'N/A'),
	dwh_performance.date_dimension.fullDate
UNION
SELECT 	dwh_performance.application_dimension.name AS 'Application',
	dwh_performance.date_dimension.fullDate AS 'Date',
	SUM(dwh_performance.volume_daily_performance_fact.writeIops) AS 'Write IOPS',
	SUM(dwh_performance.volume_daily_performance_fact.readIops) AS 'Read IOPS',
	SUM(dwh_performance.volume_daily_performance_fact.writeThroughput) AS 'Write Throughput',
	SUM(dwh_performance.volume_daily_performance_fact.readThroughput) AS 'Read Throughput',
	ROUND(AVG(dwh_performance.volume_daily_performance_fact.readResponseTime), 2) AS 'Read Latency',
	ROUND(AVG(dwh_performance.volume_daily_performance_fact.writeResponseTime), 2) AS 'Write Latency',
	NULL as 'CPU Utilization',
	NULL as 'Memory Utilization'

FROM 	dwh_performance.volume_daily_performance_fact
JOIN 	dwh_performance.application_dimension
ON 	dwh_performance.volume_daily_performance_fact.applicationTk = dwh_performance.application_dimension.tk
JOIN 	dwh_performance.date_dimension
ON 	dwh_performance.volume_daily_performance_fact.dateTk = dwh_performance.date_dimension.tk
AND 	dwh_performance.date_dimension.fullDate &gt;= (SELECT MAX(dwh_performance.date_dimension.fullDate)
							FROM 	dwh_performance.date_dimension
							JOIN 	dwh_performance.volume_daily_performance_fact
							ON 	dwh_performance.volume_daily_performance_fact.dateTk = dwh_performance.date_dimension.tk
							) - INTERVAL 30 DAY
GROUP BY
	dwh_performance.application_dimension.id,
	dwh_performance.date_dimension.fullDate
UNION
SELECT 	dwh_performance.application_dimension.name AS 'Application',
	dwh_performance.date_dimension.fullDate AS 'Date',
	SUM(dwh_performance.internal_volume_daily_performance_fact.writeIops) AS 'Write IOPS',
	SUM(dwh_performance.internal_volume_daily_performance_fact.readIops) AS 'Read IOPS',
	SUM(dwh_performance.internal_volume_daily_performance_fact.writeThroughput) AS 'Write Throughput',
	SUM(dwh_performance.internal_volume_daily_performance_fact.readThroughput) AS 'Read Throughput',
	ROUND(AVG(dwh_performance.internal_volume_daily_performance_fact.readResponseTime), 2) AS 'Read Latency',
	ROUND(AVG(dwh_performance.internal_volume_daily_performance_fact.writeResponseTime), 2) AS 'Write Latency',
	NULL as 'CPU Utilization',
	NULL as 'Memory Utilization'



FROM 	dwh_performance.internal_volume_daily_performance_fact
JOIN 	dwh_performance.application_dimension
ON 	dwh_performance.internal_volume_daily_performance_fact.applicationTk = dwh_performance.application_dimension.tk
JOIN 	dwh_performance.date_dimension
ON 	dwh_performance.internal_volume_daily_performance_fact.dateTk = dwh_performance.date_dimension.tk
AND 	dwh_performance.date_dimension.fullDate &gt;= (SELECT MAX(dwh_performance.date_dimension.fullDate)
							FROM 	dwh_performance.date_dimension
							JOIN 	dwh_performance.internal_volume_daily_performance_fact
							ON 	dwh_performance.internal_volume_daily_performance_fact.dateTk = dwh_performance.date_dimension.tk
							) - INTERVAL 30 DAY
GROUP BY
	dwh_performance.application_dimension.id,
	dwh_performance.date_dimension.fullDate</sqlText>
		<mdProjectedItems><mdProjectedItem name="Application"/><mdProjectedItem name="Date"/><mdProjectedItem name="Write IOPS"/><mdProjectedItem name="Read IOPS"/><mdProjectedItem name="Write Throughput"/><mdProjectedItem name="Read Throughput"/><mdProjectedItem name="Read Latency"/><mdProjectedItem name="Write Latency"/><mdProjectedItem name="CPU Utilization"/><mdProjectedItem name="Memory Utilization"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Application"><expression>[SQL2].[Application]</expression></dataItem><dataItem name="Date"><expression>[SQL2].[Date]</expression></dataItem><dataItem aggregate="total" name="Write IOPS"><expression>[SQL2].[Write IOPS]</expression></dataItem><dataItem aggregate="total" name="Read IOPS"><expression>[SQL2].[Read IOPS]</expression></dataItem><dataItem aggregate="total" name="Write Throughput"><expression>[SQL2].[Write Throughput]</expression></dataItem><dataItem aggregate="total" name="Read Throughput"><expression>[SQL2].[Read Throughput]</expression></dataItem><dataItem aggregate="average" name="Read Latency"><expression>[SQL2].[Read Latency]</expression></dataItem><dataItem aggregate="average" name="Write Latency"><expression>[SQL2].[Write Latency]</expression></dataItem><dataItem name="Total IOpS" aggregate="total"><expression>[Write IOPS]+[Read IOPS]</expression></dataItem><dataItem name="Total Latency (ms)" aggregate="average"><expression>[Read Latency]+[Write Latency]</expression></dataItem><dataItem name="Total MBps" aggregate="total"><expression>[Write Throughput]+[Read Throughput]</expression></dataItem><dataItem name="CPU Utilization" aggregate="average"><expression>[SQL2].[CPU Utilization]</expression></dataItem><dataItem name="Memory Utilization" aggregate="average"><expression>[SQL2].[Memory Utilization]</expression></dataItem></selection>
		<detailFilters><detailFilter use="optional"><filterExpression>[Application] in ?sApp?</filterExpression></detailFilter></detailFilters></query><query name="Application Prompt">
			<source>
				
			<sqlQuery name="SQL3" dataSource="dwh_inventory" type="passThrough">
			<sqlText>SELECT
dwh_inventory.application.name as 'Application'

FROM dwh_inventory.application
WHERE dwh_inventory.application.name&lt;&gt;'N/A'
ORDER BY dwh_inventory.application.name</sqlText>
		<mdProjectedItems><mdProjectedItem name="Application"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Application"><expression>[SQL3].[Application]</expression></dataItem></selection>
		<detailFilters><detailFilter use="optional"><filterExpression>[Application] in ?sApp?</filterExpression></detailFilter></detailFilters></query><query name="Application Inventory"><source><sqlQuery name="SQL1" dataSource="dwh_capacity" type="passThrough">
			<sqlText>SELECT DISTINCT
dwh_inventory.application.name as 'Application',
'SAN' as 'Type',
dwh_inventory.volume.name as 'Volume',
dwh_inventory.storage_pool.name as 'Pool Name',
dwh_inventory.storage.name as 'Storage',
SUBSTRING_INDEX(dwh_inventory.host.name,'.',1) as 'Host',
dwh_inventory.volume.capacityMB/1024 as 'Allocated (GB)'

FROM dwh_inventory.volume
JOIN dwh_inventory.volume_in_storage_pool
ON   dwh_inventory.volume_in_storage_pool.volumeid=dwh_inventory.volume.id
JOIN dwh_inventory.storage_pool
ON   dwh_inventory.storage_pool.id=dwh_inventory.volume_in_storage_pool.storagepoolid
JOIN dwh_inventory.storage
ON   dwh_inventory.storage.id=dwh_inventory.storage_pool.storageid
JOIN dwh_inventory.volume_mask
ON   dwh_inventory.volume_mask.storageid=dwh_inventory.storage.id
JOIN dwh_inventory.host
ON   dwh_inventory.host.id=dwh_inventory.volume_mask.hostid
JOIN dwh_inventory.volume_to_application
ON   dwh_inventory.volume_to_application.volumeid=dwh_inventory.volume.id
JOIN dwh_inventory.application
ON   dwh_inventory.application.id=dwh_inventory.volume_to_application.applicationid

GROUP BY dwh_inventory.application.id, dwh_inventory.volume.id

UNION


SELECT DISTINCT
dwh_inventory.application.name as 'Application',
'NAS' as 'Type',
dwh_inventory.internal_volume.name as 'Volume',
dwh_inventory.storage_pool.name as 'Pool Name',
dwh_inventory.storage.name as 'Storage',
null as 'Host',
dwh_inventory.internal_volume.totalAllocatedCapacityMB/1024 as 'Allocated (GB)'

FROM dwh_inventory.internal_volume
JOIN dwh_inventory.storage_pool
ON   dwh_inventory.storage_pool.id=dwh_inventory.internal_volume.storagepoolid
JOIN dwh_inventory.storage
ON   dwh_inventory.storage.id=dwh_inventory.storage_pool.storageid
JOIN dwh_inventory.internal_volume_to_application
ON   dwh_inventory.internal_volume_to_application.internalvolumeid=dwh_inventory.internal_volume.id
JOIN dwh_inventory.application
ON   dwh_inventory.application.id=dwh_inventory.internal_volume_to_application.applicationid

GROUP BY dwh_inventory.application.id, dwh_inventory.internal_volume.id

UNION


SELECT 	
	dwh_capacity.application_dimension.name AS 'Application',
	'VM' as 'Type',
	null as 'Volume',
	null as 'Pool Name',
	dwh_capacity.storage_dimension.name as 'Storage',
	dwh_capacity.vm_dimension.name as 'Host',
	ROUND(SUM(dwh_capacity.vm_capacity_fact.provisionedMB)/1024, 2) AS 'Allocated (GB)'
	
	
FROM 	dwh_capacity.vm_capacity_fact
JOIN 	dwh_capacity.date_dimension
ON 	dwh_Capacity.vm_capacity_fact.dateTk = dwh_capacity.date_dimension.tk
AND 	dwh_capacity.date_dimension.latest = 1
JOIN 	dwh_capacity.business_entity_dimension
ON 	dwh_capacity.vm_capacity_fact.businessEntityTk = dwh_capacity.business_entity_dimension.tk
JOIN 	dwh_capacity.application_dimension
ON 	dwh_capacity.vm_capacity_fact.applicationTk = dwh_capacity.application_dimension.tk
JOIN 	dwh_capacity.tier_dimension
ON 	dwh_capacity.vm_capacity_fact.tierTk = dwh_capacity.tier_dimension.tk
JOIN 	dwh_capacity.vm_dimension
ON 	dwh_capacity.vm_capacity_fact.vmTk = dwh_capacity.vm_dimension.tk
JOIN    dwh_capacity.storage_dimension
ON      dwh_capacity.storage_dimension.tk=dwh_capacity.vm_capacity_fact.storagetk

GROUP BY
	
	dwh_capacity.application_dimension.tk
	





</sqlText>
		<mdProjectedItems><mdProjectedItem name="Application"/><mdProjectedItem name="Type"/><mdProjectedItem name="Volume"/><mdProjectedItem name="Pool Name"/><mdProjectedItem name="Storage"/><mdProjectedItem name="Host"/><mdProjectedItem name="Allocated (GB)"/></mdProjectedItems></sqlQuery></source><selection><dataItem name="Application"><expression>[SQL1].[Application]</expression></dataItem><dataItem name="Type"><expression>[SQL1].[Type]</expression></dataItem><dataItem name="Volume"><expression>[SQL1].[Volume]</expression></dataItem><dataItem name="Pool Name"><expression>[SQL1].[Pool Name]</expression></dataItem><dataItem name="Storage"><expression>[SQL1].[Storage]</expression></dataItem><dataItem name="Host"><expression>[SQL1].[Host]</expression></dataItem><dataItem name="Allocated (GB)"><expression>[SQL1].[Allocated (GB)]</expression></dataItem></selection><detailFilters><detailFilter use="optional"><filterExpression>[Application] in ?sApp?</filterExpression></detailFilter></detailFilters></query><query name="Application Forecast - ETL">
			<source>
				
			<sqlQuery name="SQL4" dataSource="dwh_inventory" type="passThrough">
			<sqlText>SELECT
dwh_custom.application_forecast.Application,
dwh_custom.application_forecast.appid,
dwh_custom.application_forecast.AllocatedGB,
dwh_custom.application_forecast.UsedGB,
dwh_custom.application_forecast.GrowthRate,
dwh_custom.application_forecast.ProjectedAllocatedGB,
dwh_custom.application_forecast.ProjectedUsedGB,
dwh_custom.application_forecast.date as 'Date'

FROM dwh_custom.application_forecast

</sqlText>
		<mdProjectedItems><mdProjectedItem name="Application"/><mdProjectedItem name="appid"/><mdProjectedItem name="AllocatedGB"/><mdProjectedItem name="UsedGB"/><mdProjectedItem name="GrowthRate"/><mdProjectedItem name="ProjectedAllocatedGB"/><mdProjectedItem name="ProjectedUsedGB"/><mdProjectedItem name="Date"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Application"><expression>[SQL4].[Application]</expression></dataItem><dataItem name="appid"><expression>[SQL4].[appid]</expression></dataItem><dataItem name="AllocatedGB"><expression>[SQL4].[AllocatedGB]</expression></dataItem><dataItem name="UsedGB" aggregate="total"><expression>[SQL4].[UsedGB]</expression></dataItem><dataItem name="GrowthRate"><expression>[SQL4].[GrowthRate]</expression></dataItem><dataItem name="ProjectedAllocatedGB"><expression>[SQL4].[ProjectedAllocatedGB]</expression></dataItem><dataItem name="ProjectedUsedGB" aggregate="total"><expression>[SQL4].[ProjectedUsedGB]</expression></dataItem><dataItem name="Date"><expression>[SQL4].[Date]</expression></dataItem></selection>
		<detailFilters><detailFilter use="optional"><filterExpression>[Application] in ?sApp?</filterExpression></detailFilter></detailFilters></query><query name="Performance Trends - ETL">
			<source>
				
			<sqlQuery name="SQL6" dataSource="dwh_inventory" type="passThrough">
			<sqlText>SELECT

dwh_custom.application_daily_performance.Application as 'Application',
dwh_custom.application_daily_performance.Date as 'Date',
dwh_custom.application_daily_performance.WriteIOPS as 'Write IOPS',
dwh_custom.application_daily_performance.ReadIOPS as 'Read IOPS',
dwh_custom.application_daily_performance.WriteThroughput as 'Write Throughput',
dwh_custom.application_daily_performance.ReadThroughput as 'Read Throughput',
dwh_custom.application_daily_performance.ReadLatency as 'Read Latency',
dwh_custom.application_daily_performance.WriteLatency as 'Write Latency',
dwh_custom.application_daily_performance.CPUUtilization as 'CPU Utilization',
dwh_custom.application_daily_performance.MemoryUtilization as 'Memory Utilization'

FROM dwh_custom.application_daily_performance 

</sqlText>
		<mdProjectedItems><mdProjectedItem name="Application"/><mdProjectedItem name="Date"/><mdProjectedItem name="Write IOPS"/><mdProjectedItem name="Read IOPS"/><mdProjectedItem name="Write Throughput"/><mdProjectedItem name="Read Throughput"/><mdProjectedItem name="Read Latency"/><mdProjectedItem name="Write Latency"/><mdProjectedItem name="CPU Utilization"/><mdProjectedItem name="Memory Utilization"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Application"><expression>[SQL6].[Application]</expression></dataItem><dataItem name="Date"><expression>[SQL6].[Date]</expression></dataItem><dataItem name="Write IOPS"><expression>[SQL6].[Write IOPS]</expression></dataItem><dataItem name="Read IOPS"><expression>[SQL6].[Read IOPS]</expression></dataItem><dataItem name="Write Throughput"><expression>[SQL6].[Write Throughput]</expression></dataItem><dataItem name="Read Throughput"><expression>[SQL6].[Read Throughput]</expression></dataItem><dataItem name="Read Latency"><expression>[SQL6].[Read Latency]</expression></dataItem><dataItem name="Write Latency"><expression>[SQL6].[Write Latency]</expression></dataItem><dataItem name="CPU Utilization" aggregate="average"><expression>[SQL6].[CPU Utilization]</expression></dataItem><dataItem name="Memory Utilization" aggregate="average"><expression>[SQL6].[Memory Utilization]</expression></dataItem><dataItem name="Total IOpS" aggregate="total"><expression>[Write IOPS]+[Read IOPS]</expression></dataItem><dataItem name="Total Latency (ms)" aggregate="average"><expression>[Read Latency]+[Write Latency]</expression></dataItem><dataItem name="Total MBps" aggregate="total"><expression>[Write Throughput]+[Read Throughput]</expression></dataItem></selection>
		<detailFilters><detailFilter use="optional"><filterExpression>[Application] in ?sApp?</filterExpression></detailFilter></detailFilters></query><query name="Chargeback + Performance Metrics - ETL">
			<source>
				
			<sqlQuery name="SQL7" dataSource="dwh_inventory" type="passThrough">
			<sqlText>SELECT

dwh_custom.chargeback_and_perf.Application as 'Application',
dwh_custom.chargeback_and_perf.AllocatedGB as 'Allocated (GB)',
dwh_custom.chargeback_and_perf.UsedGB as 'Used (GB)',
dwh_custom.chargeback_and_perf.TotalAverageIOPS as 'Total Average IOPS',
dwh_custom.chargeback_and_perf.PeakTotalIOPS as 'Peak Total IOPS',
dwh_custom.chargeback_and_perf.TotalAverageMBps as 'Total Average MB/s',
dwh_custom.chargeback_and_perf.PeakTotalMBps as 'Peak Total MB/s',
dwh_custom.chargeback_and_perf.AverageLatency as 'Average Latency',
dwh_custom.chargeback_and_perf.PeakLatency as 'Peak Latency'

FROM dwh_custom.chargeback_and_perf


</sqlText>
		<mdProjectedItems><mdProjectedItem name="Application"/><mdProjectedItem name="Allocated (GB)"/><mdProjectedItem name="Used (GB)"/><mdProjectedItem name="Total Average IOPS"/><mdProjectedItem name="Peak Total IOPS"/><mdProjectedItem name="Total Average MB/s"/><mdProjectedItem name="Peak Total MB/s"/><mdProjectedItem name="Average Latency"/><mdProjectedItem name="Peak Latency"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Application"><expression>[SQL7].[Application]</expression></dataItem><dataItem name="Allocated (GB)" aggregate="total"><expression>[SQL7].[Allocated (GB)]</expression></dataItem><dataItem name="Used (GB)" aggregate="total"><expression>[SQL7].[Used (GB)]</expression></dataItem><dataItem name="Total Average IOPS" aggregate="total"><expression>[SQL7].[Total Average IOPS]</expression></dataItem><dataItem name="Peak Total IOPS"><expression>[SQL7].[Peak Total IOPS]</expression></dataItem><dataItem name="Total Average MB/s" aggregate="total"><expression>[SQL7].[Total Average MB/s]</expression></dataItem><dataItem name="Peak Total MB/s"><expression>[SQL7].[Peak Total MB/s]</expression></dataItem><dataItem name="Average Latency" aggregate="average"><expression>[SQL7].[Average Latency]</expression></dataItem><dataItem name="Peak Latency"><expression>[SQL7].[Peak Latency]</expression></dataItem><dataItem name="Used (%)"><expression>[Used (GB)]/[Allocated (GB)]</expression></dataItem></selection>
		<detailFilters><detailFilter use="optional"><filterExpression>[Application] in ?sApp?</filterExpression></detailFilter></detailFilters></query></queries><namedConditionalStyles><advancedConditionalStyle name="Conditional Style 1"><styleCases><styleCase><style><CSS value="color:#CF2128"/></style><reportCondition>[Capacity Changes].[Raw Change] &lt; 0</reportCondition></styleCase><styleCase><style><CSS value="color:#77BF72"/></style><reportCondition>[Capacity Changes].[Raw Change] &gt; 0</reportCondition></styleCase></styleCases><styleDefault><style><CSS value="color:#808080"/></style></styleDefault></advancedConditionalStyle><advancedConditionalStyle name="Conditional Style 2"><styleCases><styleCase><style><CSS value="color:#CF2128"/></style><reportCondition>[Capacity Changes].[Usable Change] &lt; 0</reportCondition></styleCase><styleCase><style><CSS value="color:#77BF72"/></style><reportCondition>[Capacity Changes].[Usable Change] &gt;0</reportCondition></styleCase></styleCases><styleDefault><style><CSS value="color:#808080"/></style></styleDefault></advancedConditionalStyle><advancedConditionalStyle name="Conditional Style 3"><styleCases><styleCase><style><CSS value="color:#CF2128"/></style><reportCondition>[Capacity Changes].[Internal Volume Allocated Change] &lt; 0</reportCondition></styleCase><styleCase><style><CSS value="color:#77BF72"/></style><reportCondition>[Capacity Changes].[Internal Volume Allocated Change] &gt; 0</reportCondition></styleCase></styleCases><styleDefault><style><CSS value="color:#808080"/></style></styleDefault></advancedConditionalStyle><advancedConditionalStyle name="Conditional Style 4"><styleCases><styleCase><style><CSS value="color:#CF2128"/></style><reportCondition>[Capacity Changes].[Volume Allocated Change] &lt; 0</reportCondition></styleCase><styleCase><style><CSS value="color:#77BF72"/></style><reportCondition>[Capacity Changes].[Volume Allocated Change] &gt; 0</reportCondition></styleCase></styleCases><styleDefault><style><CSS value="color:#808080"/></style></styleDefault></advancedConditionalStyle><advancedConditionalStyle name="Conditional Style 5"><styleCases><styleCase><style><CSS value="color:#CF2128"/></style><reportCondition>[Capacity Changes].[Used Change] &lt; 0</reportCondition></styleCase><styleCase><style><CSS value="color:#77BF72"/></style><reportCondition>[Capacity Changes].[Used Change] &gt; 0</reportCondition></styleCase></styleCases><styleDefault><style><CSS value="color:#808080"/></style></styleDefault></advancedConditionalStyle><advancedConditionalStyle name="Conditional Style 6"><styleCases><styleCase><style><CSS value="color:#CF2128"/></style><reportCondition>[Capacity Changes].[Free Change] &lt; 0</reportCondition></styleCase><styleCase><style><CSS value="color:#77BF72"/></style><reportCondition>[Capacity Changes].[Free Change] &gt; 0</reportCondition></styleCase></styleCases><styleDefault><style><CSS value="color:#808080"/></style></styleDefault></advancedConditionalStyle></namedConditionalStyles><reportVariables><reportVariable type="boolean" name="showLabel">
			<reportExpression>[Performance Trends - ETL].[CPU Utilization] is null</reportExpression>
			<variableValues>
				<variableValue value="1"/>
			</variableValues>
		</reportVariable><reportVariable type="boolean" name="showLabel2">
			<reportExpression>[Performance Trends - ETL].[Memory Utilization] is null</reportExpression>
			<variableValues>
				<variableValue value="1"/>
			</variableValues>
		</reportVariable></reportVariables></report>